EnableEvents starting out as False on userform initialization???

[birdieman]

I understand how EnableEvents works and I have "If EnableEvents = FALSE Then Exit" code in each BeforeUpdate event on my userform. My issue is that, for some reason, EnableEvents is starting out as FALSE when I run the userform (from the VB editor) even though I did not set it that way. My initialize event has one line (it will eventually have more), which sets a variable value, and nothing else. When I add "enableevents=True" to my one-line initialization code, all textboxes work correctly.

So my questions

1. Is EnableEvents automatically set to FALSE when the userform is run from the VB editor?

2. Any other thoughts?

thanks

 

[RickXL]

Hi,

The main issue I get with EnableEvents is when I disable events at the start of a macro and re-enable them at the end. Everything is OK until the code fails for some reason and the final re-enabling does not happen.

I usually write my code like this:

Sub Events()
    On Error GoTo err
    Application.EnableEvents = False
    
    ' carry out processing here
    
err:
    Application.EnableEvents = True
End Sub

Regards,

 

[mikerickson]

EnableEvents is a boolean variable that you created. It initially starts with the default value, False.
You need to set it to true in the Userform's Intialize event.

(This is why I prefer a DisableEvents variable)

 

[birdieman]

thanks to both of you -- I learn something every time I come here. (I will read up on Disable Events)

 

[mikerickson]

No, don't read up on Disable Events. There is nothing to read up on.

DisableEvents is a variable that I use in several projects.
Just as EnableEvents is a variable that other use in their projects.

They are different variable names for inverse approaches to manually controlling user form event code.

The EnableEvents mentioned in the OP is very different than the Application.EnableEvents that is a part of the Excel object model.