Stop Code Execution

Microsoft VBA

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 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: .

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

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.