Help attaching macros to combo box

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

Originally Posted by BarryRiley

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

No one?

Apologies. It's a combo box from the 'form controls'