Is it possible that any change in value selected from a Data Validation drop
down list would fire a module to clear cells.

I know how to write a clear cells macro but not sure on the change event
type fire procedure

Thanks

Hi
use the worksheet_change event (for Excel 2000+). See:
http://www.cpearson.com/excel/events.htm

--
Regards
Frank Kabel
Frankfurt, Germany

"John" schrieb im Newsbeitrag
...
Is it possible that any change in value selected from a Data
Validation drop
down list would fire a module to clear cells.

I know how to write a clear cells macro but not sure on the change
event
type fire procedure

Thanks