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

's Computer Specifications

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

's Computer Specifications

Check your post in .excel

Michael wrote:
>
> 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

--

Dave Peterson

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to execute macro when selecting user-defined menu in ribbon	Mathieu936	Microsoft Excel Programming	6	11th Jun 2010 08:36 PM
Data Validation - Drop Down for User Form	wx4usa	Microsoft Excel Misc	2	24th Oct 2008 03:28 PM
Excel does not execute a button's code when another macro simulates mouse movements & clicks	Zachary_Harrison@putnam.com	Microsoft Excel Programming	2	16th Jul 2007 07:25 PM
How can I execute a macro right after the user clicks the validation drop down?	Michael	Microsoft Excel Discussion	2	23rd Dec 2006 08:59 PM
Selecting from a Validation Drop Down Box aborts macro	Lreeder	Microsoft Excel Worksheet Functions	0	27th Aug 2005 01:41 AM