Marco using drop down menu

[John252058]

I'm a newbie using VBA. I have a spread sheet to create a cultist for parts. Within this spreadsheet I have several macros to copy and paste information to the cultist page.
I would like to create a macro that will run the appropriate macro by selecting the proper macro name from a drop down menu then click the button.

 

[My Aswer Is This]

In post one you said:

by selecting the proper macro name from a drop down menu

In post 8 you said:

My data validation list contains the following #'s 1000, 1100, 1200, 1300, 1400, 1500, 2000, 2100, 2200, 2300, 2400, 2500, the list located in C12​

<strike></strike>

You cannot name a Macro: 1000 or 1100 etc.
​

 

[John252058]

I'm unable to change the macro names to match the model #'s in C12, so I'll need to use names in the data validation list to match up with the macro names. In the data validation list I'll need to have several names such as Square, Cathedral, Country, Shaker, Arch, Tombstone, Mitre, etc. Thanks for your help, its very much appreciated.