Pulldown selection lists and Worksheet_Change
I have an application that has a couple of cells with a pulldown list bound to
a few named ranges. When changes occur on these cells, the
Worksheet_Change event is fired off and application reacts accordingly.
However, I have a third set that (I believe) is defined very much in the same
fashion (Data-Validation set the List to myRange, which is a set of 10
cells)
The third list here works just fine, however It does NOT fire off a Worksheet_
Change event like the others do. Is there some sort of property that I'm
supposed to set ?
Appreciate any input.
Thanks,
Chad
|