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