Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Ryan,
An easy way to control execution of code is to use a global boolean, and check that value for a state: Public boolUFEventsDisabled As Boolean Set it to true using some event, like the form load, or a button click: boolUFEventsDisabled = True Then at the top of all events, use If boolUFEventsDisabled Then Exit Sub and have some way to re-enable it... HTH, Bernie MS Excel MVP "Ryan H" wrote in message ... Is there a way to keep userform events from firing? I don't want my Combobox_Change Events firing when I click my command button. -- Cheers, Ryan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Disable all Control Events on a Userform when it is Intialized | Excel Programming | |||
Events won't Disable! | Excel Discussion (Misc queries) | |||
Disable events | Excel Programming | |||
Disable Events | Excel Programming | |||
Disable Key Events | Excel Programming |