Userform Initialize

[kylekelsch]

What is the difference between Userform Initialize and Userform
Activate?

 

[Guest]

I wasn't aware of the UserForm Activate event. Where can I find that?
The UserForm_Initialize method provides the facility to load list boxes,
combo boxes and other controls. It occurs during the UserForm.Show event.

 

[Guest]

Sorry about that, Kyle. I learned something new. I had never used
UserForm.Activate before, but according to the VBA help files, there is such
a thing. I normally just use the UserForm.Show method which activates the
UserForm. So the difference is that the activate event simply sets focus to
the form whereas the initialize process allows the controls on the form to be
set up for use in one procedure.

 

[kylekelsch]

I see. That makes sense. Thanks for your response.

 

[zz]

The Userform_Initialize event is "triggered" once the userform is loaded in
memory, it is helpful if you want a routine to load/run before the userform
gets visible.

The Userform_activate event is [once more] "triggered" when the user clicks
or calls the userform when it has already been loaded in memory and it has
lost the focus, or receives it for the first time, it is like the got_focus
event of any control.



--
--
--
Error: App. "GetUpAndWork.exe" couldn't be loaded, "ImToTired.exe" is
blocking it's execution.
--
Walter R . [zz]

| What is the difference between Userform Initialize and Userform
| Activate?
|