title: How do I load every UserForm without having to call .Show individually?
body: <p>I wanted to figure out how you could load every UserForm without having to call <code>Userform1.Show</code> <code>UserForm2.Show</code> etc. This was inspired by comments on this answer: <a href="https://stackoverflow.com/a/13964853/1316573">Excel VBA UserForm_Initialize() in Module</a>. </p>
  
  <p>I found this method suggested in a few places:</p>
  
  <pre><code>Sub OpenAllUserForms()
      Dim uf As UserForm
      For Each uf In UserForms
          uf.Show
      Next
  End Sub
  </code></pre>
  
  <p>However, no Userforms display regardless of how many are attached to the workbook. When I stepped through the code I determined that the UserForms collection is empty! </p>
  
  <p>How can I load each Userform without having to explicitly show each one?</p>