title: Excel VBA - Pause code execution
body: <p>I have a complex VBA function and a workbook with multiple sheets.
  Let's say the code goes through every row of Sheet1 and does something with that data.</p>
  
  <p>I would like to be able to pause on <code>SourceRow = 16</code>, check out results I'm getting on different sheets and then continue on (press ok, or some key stroke)</p>
  
  <p>I've tried</p>
  
  <pre><code>If SourceRow = 16 Then
      MsgBox "ReachedRow 16"
  End If
  </code></pre>
  
  <p>But the Message box is modal and I can not switch to a different sheet(s) to see the data.</p>
  
  <p>P.S. 16 is just as an example, hardcoded for now but will not be later on.</p>