Activate Event

This event is fired every time the userform becomes the active window
The Activate and Deactivate events only occur when the focus is moved within the application.
Moving the focus to another application will not trigger these events.
The Activate event fires after the Show method is activated

Private Form_Activate() 
End Sub