Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have two cells with data validation (each using a named range/list that
brings in data from another sheet). When one changes, it runs through my code and works just fine. When the other data validation changes, one of the things I have to do is re-set the other data validation cell to the default value. This part is working fine, except that it triggers the worksheet_change event to run a second time. Is there an elegant way to catch/ignore the worksheet_change event when changes are caused by code instead of user interaction? Thanks, Keith |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Trigger Event Code | Excel Programming | |||
Code to trigger drop down-select event | Excel Programming | |||
Code WAY too slow... (worksheet_change event) | Excel Programming |