View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ChadF ChadF is offline
external usenet poster
 
Posts: 44
Default 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