Form Initialize Event

[Hap]

I just realized that when I load a UserForm and start setting the values of the controls that the code starts running the click events for those controls. If I use an initialize event (syntax?) will that eliminate the click events executing?

Thank you.

 

[xenou]

Not necessarily - events will fire because of actions you take in the initialize event too.

 

[Hap]

Thank you. Is there an effective way to circumvent this without a lot of extraneous code?

 

[xenou]

It depends.

If something triggers an event, you should try to write the code so that there are no exceptions - that is, no cases where you sometimes want the event to fire and sometimes not. That is, let your events do the work and don't try to avoid them.

Worst case (I consider this poor design for user forms):
create a private variable called "SuppressEvents" or what have you. When you write your event code:

Sub Some_Event()
If Not SuppressEvents Then
    'Do event code
End If
End Sub

Then you can avoid the event with:

SuppressEvents = True
TriggerEvent()
SuppressEvents = False

 

[Hap]

I think that answers my question. My main purpose isn't that the event is doing something unwanted, just unnecessary and ultimately inefficient. If I get to the point where the events are consuming too much time on loading the form then I might look to stop them.

Thanks for the help.

 

[xenou]

I worked through a similar case once. In fact I did use the hack described above to shut off events for some combo boxes or list boxes that I was manipulating. ultimately weeded them out to the point where I could let the events fire and everything was triggered purely through the event code itself. I learned a lot about form events in the process - I think I even created a label on the form to list the events as they fired so I could understand what was happening when my form opened. But I believe I ended up with one listbox that I know was being loaded twice when the form opened - so I couldn't work it out to perfection {sigh}.

 

[Hap]

I'm hoping to develop some of that efficiency with experience. Thanks again for the help.