This article demonstrates how to execute a VBA macro using a drop down list. The drop down list contains multiple macro names.
The following animated picture shows you a drop down list containing two text strings, Macro1 and Macro2. When I select Macro1 in cell B2 a worksheet event code reads the selected value and runs a macro. The macros show a message box with the message Macro1 or Macro2 depending on the selected value.
Watch this video where I explain how to run a macro from a drop down list