I have been searching on the internet for about 2 hours and cannot for the life of me find the answer.
I have a combo box which has the names of the different sheets in my spreadsheet. When a sheet is selected from the drop down menu I want it to switch to that sheet. I assumed I could do this with a macro but all I can seem to do is attach the macro to the entire combo box rather than the individual selections.
Please help, I'm going insane
Re: Help attaching macros to combo box
No one?Originally Posted by BarryRiley
Don't quote who;e posts for no reason.
What kind of combobox are you using?
Hope that helps.
RoyUK
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel Tips & Solutions, free examples and tutorials why not check out my downloads
New members please read & follow the Forum Rules
Remember to mark your questions Solved and rate the answer(s)
Apologies. It's a combo box from the 'form controls'
Post the macro code. Remember to use code tags:
[CODE]
your code here
[/CODE]
---
Ben Van Johnson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks