LinkBack URL
About LinkBacks
Hi
I have many userfoms and I was wondering whether I could select a userform from a combobox in a worksheet. I have tried to play around with codes but can't seem to get this to work.
Regards.
Show UserForm from ComboBox
Hi
I have many userfoms and I was wondering whether I could select a userform from a combobox in a worksheet. I have tried to play around with codes but can't seem to get this to work.
Regards.
Last edited by sgp; 11-17-2011 at 08:48 AM.
cfr the attachment
Hmm doesn't seem to work for me..
I have copied this code in the worksheet:
Please Login or Register to view this content.
and this in the workbook:
Please Login or Register to view this content.
hi sgp,
it works for me, try to save and open it again.
Regards, John55
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
...enjoy -funny parrots-
Hi john55,
I'm getting an error on this line:
[code]
Sheets(5).ComboBox1.List = Split(Mid(c01, 2), "|")
[code]
Would I need to enter the sheet number or name?
Use the sheet's name.
Have you got a combobox in the sheet ?
I do not know how yr workbook looks like, for example I added a new ComboBox in Sheet1 and ammended the code for that ComboBox and added
snb, I'm sorry, hope you do not mind...Please Login or Register to view this content.
Last edited by john55; 11-17-2011 at 08:12 AM.
Thanks snb and john55,
Finally works great! What I wasn't doing was saving the worksheet as macro-enabled!!
Thanks!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks