Can anyone direct me on a simple macro code that will call another macro
(that clear cells) when a value in a cell, say B10 changes to anything. This
value in B10 comes from a data validation drop down. I believe I need a
worksheet_calculate event, I've loked at a few sites http://www.cpearson.com
being one but I'm confused about how to create one. I need it working from
Excel97 and 2000 in case that makes any difference


Thanks