title: Excel Userform stuck on .show
body: <p>I have two user forms. The first is UI to allow different ways for data to be processed. The second is a progress bar. The first on works fine, but when the second one is called, it stalls on <code>.show</code>.</p>
  
  <pre><code>Sub ShowProgressBar()
    With ProgressBar
      Debug.Print "Progress Bar Called: " &amp; Time
      .LabelProgress.Width = 0
      .Show
      Debug.Print "Progress Bar Shown: " &amp; Time
    End With
  End Sub
  </code></pre>
  
  <p>I've added <code>UserForm_Activate()</code> event to see if the form was looking for one and stalling there. It called it, but never moved off the <code>.show</code>. I've seen this by it not going to the second <code>debug.print</code> statement. I've used <code>ctrl+break</code> and the <code>.show</code> is always the line highlighted. I've tried hiding the first form to see if there was an issue there, but no luck.</p>
  
  <p>Code Calling the userform: </p>
  
  <pre><code>Me.Hide
  ProgressBar.ShowProgressBar
  </code></pre>
  
  <p>Any ideas on why this is happening and how to solve? I would like to keep this as a separate Userform so it can be used in other projects.</p>