Using a Userform ComboBox to activate specific worksheet
Good evening all,
I realize this is probably a bit silly, so please keep in mind I am still an amateur at best when it comes to VBA. I am trying to have a ComboBox activate a specific sheet based on the value of "ComboBox1.Column(1)". I have many sheets to select from so i want to avoid using the Case method, is this possible? Here is a small sample of my code that isn't working:
Any help would be greatly appreciated
Please Login or Register to view this content.
hi,
as an option you can use a UserForm having a ComboBox1, and use the first piece of code for ComboBox1 itself
and for UserFormPlease Login or Register to view this content.
and this one for yr buttonPlease Login or Register to view this content.
Please Login or Register to view this content.
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-
Thank's for the response, I tried what you suggested and could not get it to work with my existing code. I have just reverted back to using the case method for now, it does the trick. I just thought there was a simpler way to write it. I will post my code and maybe someone knows a cleaner way to write it
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks