MrExcel Publishing
Your One Stop for Excel Tips & Solutions

combo_box with macro properties

Posted by Peter Cohen on January 15, 2002 7:56 PM

Can anyone help me please. I am trying to create a combo_box that when you select your choise it takes you to another sheet in the same workbook. I have a workbook with about 34 pages on it and would like to be able to get to any of them through this combo_box.

Posted by Richie Turner on January 16, 2002 4:15 AM

Hi Peter

If the sheet you want to go to depends on the selection from the combo box, you can create a macro in the Change Event of the combo box that uses a SELECT CASE statement to direct it to any sheet using sheets("sheetname").select

You can then assign a macro to the combo box (point to combo box on the sheet, right-click and select assign macro) so that when you make a selection from the combo box it fires the macro.

I have something similar in one of my files. Please email me if you need any more help.