title: which event fires if excel-vba modeless userform window gets focus back?
body: <p>I've got a modeless userform in an Excel VBA project.
  The userform is loaded by button on spreadsheet clicked (<em>not</em> an active-x button if that's relevant).
  Because of modeless the user can work with excel or even other applications and than switch back to the form window. <strong>I need an event that fires if the form window becomes the active window again.</strong> I thought <code>UserForm_Activate</code> should do the job but it doesn't (neither does <code>UserForm_GotFocus</code> but there is no GotFocus event for userforms?). Is there any event that fires if the user switches back to a modeless userform (or in case not: is there any known work-around)? Or do I've got some strange bug here and <code>Activate</code> should fire?</p>
  
  <p>Here's all the code I used for testing purpose:</p>
  
  <pre><code>' standard module:
  
  Sub BUTTON_FormLoad()
      ' associated as macro triggered by button click on a sheet
      UserForm1.Show vbModeless
  End Sub
  
  
  ' UserForm1:
  
  Private Sub UserForm_Activate()
      ' does not fire if focus comes back
      Debug.Print "Activated"
  End Sub
  
  Private Sub UserForm_GotFocus()
      ' does not fire if focus comes back
      ' wrong code - no GotFocus event for userforms?
      Debug.Print "Focussed"
  End Sub
  
  Private Sub UserForm_Click()
      ' only fires if clicked *inside* form
      ' does not fire eg if user clicks top of form window
      Debug.Print "Clicked"
  End Sub
  </code></pre>
  
  <p>Where do I find the documentation of userform events? It's not on the '<a href="https://docs.microsoft.com/de-de/office/vba/language/reference/user-interface-help/userform-object" rel="nofollow noreferrer">UserForm object</a>' page.</p>