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
Bookmarks