UserForm Initialize and Activate

[AD_Taylor]

Is there any difference between:

Private Sub UserForm_Activate()

End Sub

and

Private Sub UserForm_Initialize()

End Sub

?

They both seem to do the same thing as far as I can tell?
Just wondering as I have a file with multiple UserForms some using Activate and some using Initialize.
Should I consolidate them to one type?

 

[squidgeny]

Here: http://www.mrexcel.com/forum/showthread.php?t=539938

 

[AD_Taylor]

Great thanks for this! I did a quick search but couldn't find anything relevant.

Looks like I'll need to switch to using 'Activate' every where then...