Disable Userform Events

  • Thread starter Thread starter Ryan H
  • Start date Start date
R

Ryan H

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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combobox_change event fires when a workbooks is saved 3
Firing Event in another user form 1
Disable all Control Events on a Userform when it is Intialized 1
user form infinit loop 6
Timer on Userform 2
closing another file by code causes failure to run workbook activate event 2
Class Raise Event not firing 3
Userform Command Button 3

Back
Top