Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can a combo box activate different macros
Hello all
I currently have a worksheet that has about 10-12 buttons on it. Each button activates a different macro that brings the user to a different sheet within the workbook. The sheet looks very cluttered with so many buttons on it and I wanted to create a combo box that will allow the user to select a worksheet name, and when the worksheet name is selected, it brings the user to that sheet. It doesn't matter to me if it activates the current macros that were created for the buttons or uses some other approach. I just want to clean the worksheet up a bit. One caviat - I'm not a programmer. I can read a little programming, but haven't written anything. Any and all help is very much appreciated! Thank you! Carrie :) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can a combo box activate different macros
Hi, Carrie.
You can establish a combo box that lists the sheets with which you wish to work. If Sheet1 is the location for the list box, place the list of sheets in a1:a5, for example, listing sheets Sheet1 through Sheet5. In the properties for the list box, refer to that range for the 'list' of choices. Set B1 for the result. When the user selects a choice, their choice will then appear in B1 In design mode, double click the combo box and a code page will appear for it. Insert code such as: Range("b1").Select mysheet = Selection Sheets(mysheet).Select Then when a user selects a sheet name it will send them to it. In the destination sheet you can place a button with code "Sheets(Sheet1).Select" to return you to the main sheet. If you have sheet tabs, etc turned off this will give users the navigation you need. " "Carrie" wrote: Hello all I currently have a worksheet that has about 10-12 buttons on it. Each button activates a different macro that brings the user to a different sheet within the workbook. The sheet looks very cluttered with so many buttons on it and I wanted to create a combo box that will allow the user to select a worksheet name, and when the worksheet name is selected, it brings the user to that sheet. It doesn't matter to me if it activates the current macros that were created for the buttons or uses some other approach. I just want to clean the worksheet up a bit. One caviat - I'm not a programmer. I can read a little programming, but haven't written anything. Any and all help is very much appreciated! Thank you! Carrie :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro that can run combo boxes | Excel Discussion (Misc queries) | |||
Help with combo boxes and macros in Excel 2003 | Excel Discussion (Misc queries) | |||
Hide Macro's in Toolbar / Macro's list | Excel Discussion (Misc queries) | |||
how do I run excel 4.0 macros on excel 2000 | Excel Discussion (Misc queries) | |||
Nesting Combo Boxes /Returning an Array | Excel Discussion (Misc queries) |