Stop statement

Suspends execution.

Syntax

Stop

Remarks

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.

Example

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

Dim i As Long 
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 

See also

• Data types
• Statements

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.