| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB code help
I have a combobox that displays a list of 'options' to the user.
I want a certain macro to run or userform to be displayed for each 'option' that is chosen. I have this code, but I can't get it to work Sub DropDown49_Change() Select Case DropDown49.Value Case "Add new Job" frmNewJob.show Case "Edit report" frmEditJobref.show Case "View old report" frmGetJob.show Case "View Adhoc Log" Sheets("adhoc").Select Case "Add Shift Report" Sheets("sheet2").Select frmReport.show End Select any help in fixing it and where to place the code would be appreciated |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| split post code (zip code) out of cell that includes full address | Excel Discussion (Misc queries) | |||
| Shorten code to apply to all sheets except a few, instead of individually naming them, and later adding to code. | Excel Programming | |||
| Protect Sheet with code, but then code will not Paste error. How do i get around this. Please read for explainations.... | Excel Programming | |||
| How to assign same code inside Option button code space ?? | Excel Programming | |||
| Excel code convert to Access code - Concat & eliminate duplicates | Excel Programming | |||
Threaded Mode
