Enable Events

[AlexanderBB]

In Userform Activate two combo box values are set, but I don't want their change events to fire.
So I put

Application.Enable Events = False

before setting the combo box text value.

But the change event runs regardless.

Isn't Enable Events = False meant to prevent that ?

 

[JLGWhiz]

In Userform Activate two combo box values are set, but I don't want their change events to fire.
So I put

Application.Enable Events = False

before setting the combo box text value.


But the change event runs regardless.

Isn't Enable Events = False meant to prevent that ?

Try it without the space between Enable and Events.

 

[AlexanderBB]

Sorry that was me typing into the message. It's correct in the code module.
I forced it to work with my own boolean, but don't get why I needed to.

 

[JLGWhiz]

Neither do I. Application.EnableEvents should turn off the event trigger, but not seeing the full code, I wouldn't have a clue.
regards, JLG

 

[AlexanderBB]

Not much code to see, just a couple of Combo Boxes and their Change event. Be interested if it *did* work.
After looking deeper it may affect Worksheet Controls only.

 

[Fluff]

EnableEvents does not work with userform controls.
You will need to build your own event handler, or change the code to use as Combo_Click event rather than a combo_Change event.

 

[Marcelo Branco]

Take a look at
http://www.cpearson.com/excel/SuppressChangeInForms.htm

M.

 

[joeu2004]

I forced it to work with my own boolean, but don't get why I needed to.

Take a look at http://www.cpearson.com/excel/SuppressChangeInForms.htm

And from that webpage: ``Application.EnableEvents does not apply to controls on a UserForm. [....] To suppress events in a form, you can create a variable at the form's module level called "EnableEvents" and set that to False before changing a property that will cause an event to be raised``.

Sounds like exactly what Alexander did. Give the man some credit. Clever guy!

PS.... In my Unix days, we used to say ``don't ask why``. (wink)

 

[JLGWhiz]

Chip Pearson's website is one of the best for insight into how vba works and how to get around the quirks of MS applications.