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.
Thank-you
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.
Richie
