userform_activate vs. userform_initialize

[jey_sea]

Whats the differance between the userform_activate vs. userform_initialize commands and if both are present in a user form, which one gets called first?
Thanks

 

[RoryA]

initialize occurs first when the form is actually loaded into memory, and activate occurs whenever it is shown.
If you hide then show a form, the activate event will fire again, but initialize will not.

 

[jey_sea]

Got it; thanks