The worksheet_change event in Excel 97 only fires if the cells on the
worksheet are changed by the user or by an external link. So changing a
cell by Data Validation does not fire the event (even if the user
selects the value from a Data Validation list). As mentioned in a
previous post, this issue is resolved in Excel 2000.

I got around this problem by using the worksheet_calculate function
instead. This *does* fire when a value in a Data Validation list box is
selected.

I hope this helps.



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!