Stop Code Execution

  • Article

This page is specific to the Visual Basic for Applications (VBA) Language Reference for Office 2010.

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: Gg278808.tbr_brk_ZA01201682(en-us,office.14).gif.

  • To switch to design time, from the Run menu, choose Reset <projectname>, or use the toolbar shortcut: Gg278808.tbr_end_ZA01201701(en-us,office.14).gif.

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.