How can I execute a macro right after the user clicks the validation drop down?

M

Michael

I have an Excel worksheet and in $D$1 it has a validation rule (in cell drop
down) that reads allowed values from A1:A3. What I want is when the user
clicks on the drop-down in A1 I want to execute some basic macro. Is their a
dropdown click event where I can capture it so before the user does anything
else I can call my macro?

Thanks in advance
Michael
 
D

Dave Peterson

Check your post in .excel
I have an Excel worksheet and in $D$1 it has a validation rule (in cell drop
down) that reads allowed values from A1:A3. What I want is when the user
clicks on the drop-down in A1 I want to execute some basic macro. Is their a
dropdown click event where I can capture it so before the user does anything
else I can call my macro?

Thanks in advance
Michael
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Validation In Excel 1
How to dynamically change the list in drop down list based on thevalue of another cell? 1
Data validation drop down list selection change 4
Select drop down menu option using libre-calc macro 0
drop down menus 2
Validation Drop Down 2
how to trigger a validation change 3
Drop Down List and macros 3

Top