Stop Code Execution

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

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 in the Options dialog box.

  • A breakpoint is encountered.

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

  • An End statement is encountered in your code, 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: tbr_brk_ZA01201682.

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

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.

Show: