ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Pulldown selection lists and Worksheet_Change (https://www.excelbanter.com/excel-programming/374884-pulldown-selection-lists-worksheet_change.html)

ChadF

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





All times are GMT +1. The time now is 10:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com