Assign Multiple Macros to Drop Down List

[rme8223]

I have a lot of data that I built macros to sort when you when to see certain categories.

I had it so if you wanted to see Portfolio A, you click a button and it sorts the list of 100 names into the 25 that are in Portfolio A, and etc for other Portfolios.

However, now I have too many buttons and I would rather be able to use a Drop Down List.

I want a drop down list with 10 names on it, where for each name that I choose from the list, it runs a different macro. Is this possible?

All I can figure it is how to assign 1 macro to the drop down list, which seems useless to me. How can I make each name on the list assigned to a macro?

[Leith Ross]

Hello rem8223,

Use this macro as the one you attach to the drop down. Change the macro names Macro1, Macro2, etc. to the names of the macros you want to run.

Sub RunMacros()
    
    With ActiveSheet.DropDowns(Application.Caller)
      Select Case .ListIndex
        Case 1
          Macro1
        Case 2
          Macro2
        Case 3
          Macro3
        Case 4
          Macro4
        Case 5
          Macro5
        Case 6
          Macro6
        Case 7
          Macro7
        Case 8
          Macro8
        Case 9
           Macro9
       Case 10
          Macro10
     End Select
   End With
        
End Sub

Adding the Macro
1. Copy the macro above pressing the keys CTRL+C
2. Open your workbook
3. Press the keys ALT+F11 to open the Visual Basic Editor
4. Press the keys ALT+I to activate the Insert menu
5. Press M to insert a Standard Module
6. Paste the code by pressing the keys CTRL+V
7. Make any custom changes to the macro if needed at this time
8. Save the Macro by pressing the keys CTRL+S
9. Press the keys ALT+Q to exit the Editor, and return to Excel.

Sincerely,
Leith Ross

[rme8223]

Leith,

Thanks for this. I'll try it out.

[ksr3571]

I have a similar task but I don't know how to assign the macro to run on the drop down list. Can someone assist?