| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select from multiple macros
I have a requisition sheet almost complete for its users. There are about 25 macros to print, change view, etc. My problem is that I cannot find an elegant way for the user to select from the macros  . I want to use a combo box, but I cannotfind a way to associate a different macro with each combo box item. Any suggestions? Thanks! Jack -- aswert1223 ------------------------------------------------------------------------ aswert1223's Profile: http://www.excelforum.com/member.php...o&userid=15771 View this thread: http://www.excelforum.com/showthread...hreadid=486971 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Select from multiple macros
use a case statement
Select Case Combobox1.ListIndex Case 0 mymacro3 Case 1 mymacro2 Case 2 mymacro5 End Select -- Regards, Tom Ogilvy "aswert1223" wrote in message ... I have a requisition sheet almost complete for its users. There are about 25 macros to print, change view, etc. My problem is that I cannot find an elegant way for the user to select from the macros . I want to use a combo box, but I cannotfind a way to associate a different macro with each combo box item. Any suggestions? Thanks! Jack -- aswert1223 ------------------------------------------------------------------------ aswert1223's Profile: http://www.excelforum.com/member.php...o&userid=15771 View this thread: http://www.excelforum.com/showthread...hreadid=486971 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Select from multiple macros
Where are you placing this ComboBox. Is it embedded in one of the
worksheets or is it attatched to a menu? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Select from multiple macros
Mark, I plan on 2 combo boxes (views & print controls) directly on the worksheet. They will not appear on the printed pages. -- aswert1223 ------------------------------------------------------------------------ aswert1223's Profile: http://www.excelforum.com/member.php...o&userid=15771 View this thread: http://www.excelforum.com/showthread...hreadid=486971 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Select multiple values | Excel Discussion (Misc queries) | |||
| Multiple Select | Excel Discussion (Misc queries) | |||
| select multiple criteria multiple worksheets | Excel Worksheet Functions | |||
| how do i select different printer trays using macros | Excel Programming | |||
| List macros for user to select... | Excel Programming | |||
Linear Mode
