Excel97 - Worksheet Change Event (?)
Posted on 2002-03-04
On a data selection worksheet, I have a cell that contains a data validation drop down list (not a form control). When the value in this cell changes I would like some code to run that will clear some input fields.
I have assigned some code to the "Worksheet_Change" event, but this only works when a change is made to the cell via the keyboard. If I use the mouse to select a different item from the list then this action is ignored by the change event.
I also tried basing the code on a different cell containing a formula based on this selected item. However, the change event does not seem t owork on formulated cells either.
How can I get the code to run when I select a new item from the data validation drop down list?