Run Macro when selecting from in-cell list (data validation)

[4am]

It has been years since I've done this but I remember it being possible.

I would like to have a drop down that runs a certain macro depending on what list item the user selects.

I searched google and the forum but could not find what I was looking for. Thanks for the help!

[BigBas]

In my opinion, the best way to do this is to name a macro after each of the items in your Data Validation List. (ie, Data Validation: Red, Green, Blue create macros named Red Green Blue).

Then, in the worksheet_change event, enter this macro (note, I'm assuming your data validation is in cell D1. Change that to suit)

Please Login or Register  to view this content.

Let me know if you can cater this to your needs

[4am]

Wow that looks like a very efficient way to do this. I'm going to try it and get back to you. Thanks!

[4am]

Thank you! It works.