Debra Dalgleish has some notes at:
http://www.contextures.com/xlDataVal08.html

And I quote (pronounced steal):

Data Validation Dropdowns and Change Events

In Excel 2000 and Excel 2002, selecting an item from a Data Validation dropdown
list will trigger a change event. This means that code can automatically run
after a user selects an item from the list.

To see an example, go to the Sample Worksheets page, and under the heading
Product List by Category, download the ProductsList.xls file.

In Excel 97, selecting an item from a Data Validation dropdown list does not
trigger a change event, unless the list items have been typed in the Data
Validation dialog box. In these versions, you can add a button to the worksheet,
and assign a macro to the button.



Greg Wilson wrote:

I recently responded to a post saying that the
Worksheet_Change event is NOT fired when a cell value is
changed by means of making a selection from a drop list -
in this case a Data Validation drop list. However, I
checked it out on a newer machine today running xl2000 and
found that it DOES WORK. I double checked and it very
definately does not work on my machine. It's been this
way for as long as I can remember. I'm running xl97.

Is this the case with xl97 or do I have yet another bug?
My machine is very old and tired to say the least.

TIA

Greg

--

Dave Peterson