| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Macros
How do I run a macro from a list box?
|
|
#2
|
|||
|
|||
|
Assuming your listbox contained a,b,c,d as entries
Private Sub ListBox1_Change() x = ListBox1.Value Select Case x Case "a" "your routine" Case "b" "your routine" Case "c" "your routine" Case "d" "your routine" End Select End Sub "Rinyma" wrote: How do I run a macro from a list box? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Enable/Disable Macros | Excel Discussion (Misc queries) | |||
| Transferring toolbars and macros to other computers | Excel Discussion (Misc queries) | |||
| How do I stop Excel from prompting to enable or disable macros? | Excel Discussion (Misc queries) | |||
| The available macros list in XL; how to suppress filename from showing | Excel Discussion (Misc queries) | |||
| Macros disappear after a file is imported | Excel Discussion (Misc queries) | |||
Linear Mode
