Differences Among Form's Initialize, and Activate Events

[Rasm]

These two events seems to me to be the same - I have been using _Activate - but it seems everybody else is using the _Initialize - can anybody tell me why to use one rather than the other.




Private Sub UserForm_Activate()

End Sub


Private Sub UserForm_Initialize()

End Sub

[Admin]

Hi,

This KB article (http://support.microsoft.com/kb/138819) would give you the answer.

Kris

[Rasm]

Hmmm - actually some significant differences - very useful - thanks