Drop Down Selection fires a module?

[John]

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

 

[Frank Kabel]

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