Stop code execution

As you run your code, it may stop executing for one of the following reasons:

  • An untrapped run-time error occurs.

  • A trapped run-time error occurs, and Break on All Errors is selected on the General tab of the Options dialog box.

  • A breakpoint is encountered.

  • A Stop statement in your code is encountered, switching the mode to break mode.

  • An End statement in your code is encountered, switching the mode to design time.

  • You halt execution manually at a given point.

  • A watch expression that you set to break if its value changes or becomes true is encountered.

To halt execution manually

  • To switch to break mode, from the Run menu, choose Break (CTRL+BREAK), or use the toolbar shortcut: image of toolbar button to switch to break mode.

  • To switch to design time, from the Run menu, choose Reset <projectname>, or use the toolbar shortcut: image of toolbar button to switch to design time.

To continue execution when your application has halted

  • From the Debug menu, choose Step Into (F8), Step Over (SHIFT+F8), Step Out (CTRL+SHIFT+F8), or Run To Cursor (CTRL+F8).

See also

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.