title: VBA - Get back to a sub after opening a userform
body: <p>I am struggling with a basic problem I don't find the answer online... I am trying to get back to my original sub after loading a userform (progressbar I created without using an Excel library).</p>
  
  <p>The code looks like this :</p>
  
  <p><strong>MODULE CODE :</strong></p>
  
  <pre><code> Sub Original_Sub()
  
   'Some code here
       Userform1.Show
   'Some code here I can't reach
  
   End sub
  </code></pre>
  
  <p><strong>USERFORM CODE :</strong></p>
  
  <pre><code> Private Sub UserForm_Initialize()
  
   With UserForm1
  
    .StartUpPosition = 0
    .Left = Application.Left + (0.5 * Application.Width) - (0.5 * .Width)
    .Top = Application.Top + (0.5 * Application.Height) - (0.35 * .Height)
  
   End With
   End Sub
  </code></pre>
  
  <p>The first part of the code is running properly, but it stops right after running the userform code... Why would not it continue like when I call a macro ? i.e :</p>
  
  <pre><code> Call MyMacro
   'Rest of the code
  </code></pre>
  
  <p>Is there any way I can solve my problem?</p>
  
  <p>Thank you in advance for your help and have a great day</p>
  
  <p>Jean</p>