Event for pick list/validation item being chosen??

[Fherrera]

Hi, I understand there is a "Worksheet_Change()" event that kicks i
once a cell's value has been changed. I have a cell where to there is
pick list to pick a value, but once this is done the Change() even
doesn't kick in. Nor, does the calculate event. (I can't get th
calculate event to work for anything, but thats besides the point

Anyway, does anyone know how to access this. Essentially, i'd like t
update all the other cells that reference this pick list cell when th
pick list cell has been modified. The way I was going to do it was us
the event, and basically do a Worksheets("Sheet1").Calculate whic
would update those values as well as others.

I'm using Excel 97 :< Any help would be appreciated. Thanks

 

[Debra Dalgleish]

There's a sample workbook on my web site that uses the Calculate event
to run an Advanced Filter:

http://www.contextures.com/excelfiles.html

Under Filters, look for 'Product List by Category' and download the file
named ProductsList97Calc.xls

 

[Fherrera]

Thank you for the reply