Expand Minimize

Stop Statement

Last modified: December 06, 2011

Applies to: Office 2013 | VBA

Suspends execution.




You can place Stop statements anywhere in procedures to suspend execution. Using the Stop statement is similar to setting a breakpoint in the code.

The Stop statement suspends execution, but unlike End, it doesn't close any files or clear variables, unless it is in a compiled executable (.exe) file.

This example uses the Stop statement to suspend execution for each iteration through the For...Next loop.

Dim I 
For I = 1 To 10 ' Start For...Next loop. 
 Debug.Print I ' Print I to the Immediate window. 
 Stop ' Stop during each iteration. 
Next I 

© 2014 Microsoft