Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create Drop Down List of Macros
Hello,
I'm using excel 2002. I have 12 macros and I want to create a drop down list for these such that when any one of the macro is selected from the list the procedure for that macro is executed. Any help would be greatly appreciated. Regards, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create Drop Down List of Macros
Youlan wrote:
Hello, I'm using excel 2002. I have 12 macros and I want to create a drop down list for these such that when any one of the macro is selected from the list the procedure for that macro is executed. Any help would be greatly appreciated. Regards, Do they appear when you pres Alt+F8? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create Drop Down List of Macros
You "want" this or just some way of accessing your macros?
To do what you want could be done with event code and some Case statements. Might be easier to create a UserForm with a menu of 12 items. Or a floating Toolbar with 12 buttons on it. But.........event code it is. With a DV dropdown list of your macros in A1 Private Sub Worksheet_Change(ByVal Target As Range) If Intersect(Target, Me.Range("A1")) Is Nothing Then Exit Sub Select Case Target.Value Case "A" 'more descriptive names should be used in place of A, B and C AMacro Case "B" BMacro Case "C" CMacro 'add more to suit End Select End Sub Gord Dibben MS Excel MVP On Fri, 23 Oct 2009 14:55:02 -0700, Youlan wrote: Hello, I'm using excel 2002. I have 12 macros and I want to create a drop down list for these such that when any one of the macro is selected from the list the procedure for that macro is executed. Any help would be greatly appreciated. Regards, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
Create a list in a drop down dependent upon another dd list in exc | Excel Discussion (Misc queries) | |||
ASSIG MACROS TO DROP DOWN LIST | Excel Discussion (Misc queries) | |||
Delete key not enabled on macros drop down list | Excel Discussion (Misc queries) | |||
Can I create a drop-down list that will reference other drop-down | Excel Worksheet Functions |