Disable Userform Events
 

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

Disable Userform Events
 

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