excel-vba Stop


The Stop command will pause the execution when called. From there, the process can be resumed or be executed step by step.

Sub Test()
    Dim TestVar as String
    TestVar = "Hello World"
    Stop                    'Sub will be executed to this point and then wait for the user
    MsgBox TestVar
End Sub