Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello Group,
I have read many of the postings regarding the fact that you can't disable form events. I have even created a Boolean called DisableEvent that I use to escape from the offending event code. My issue that I'm having is that I have 2 comboboxes and when I change the value of Box 1 (From A to B) it needs to clear the value of Box 2. When the Box 2 change event gets triggered the value of the box goes back to the original value (from B back to A) regardless of the fact that I am exiting the procedure before the code is executed. Any ideas? Here's the psuedocode of what's happening. Box1 value is changed from A to B Box1_OnChange DisableEvent = True Change Box 2 value to "" <This will trigger the Box2 Change Event DisableEvent = False .... .... Box2_OnChange <This is when the value goes back to A If DisableEvent = True then Exit Sub ..... ..... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Events won't Disable! | Excel Discussion (Misc queries) | |||
disable events while macro is running | Excel Programming | |||
Worksheet events - when are they triggered! | Excel Programming | |||
Disable Events | Excel Programming | |||
Disable Key Events | Excel Programming |