View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
 
Posts: 5,441
Default 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