Data Validation and Macro

[Mr.Z]

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

 

[pfsardella]

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