Hi

I created a drop down list using data validation, What I want is to be able
to run a macro automatically when I click on of the items on the list, I
don't know if that possible or no.

Thanks

Debra Dalgleish has a fairly comprehensive WebPage on Data
Validation. I don't believe that feature has the capability to run
macros.

http://www.contextures.com/xlDataVal01.html

I usually use Combo Boxes (DropDowns) from the Forms Toolbar for that
capability.


HTH
Paul
--------------------------------------------------------------------------------------------------------------
Be advised to back up your WorkBook before attempting to make changes.
--------------------------------------------------------------------------------------------------------------

Hi

I created a drop down list using data validation, What I want is to be able
to run a macro automatically when I click on of the items on the list, I
don't know if that possible or no.

Thanks