Use Quick Watch

  • Article

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

In break mode, you may want to check the current value of a variable or expression for which you haven't defined a watch expression. Do this using the Quick Watch command.

To display a Quick Watch

  1. Select an expression in the module where it resides.

  2. From the Debug menu, choose Quick Watch (SHIFT+F9). The Quick Watch dialog box displays the current value of the expression you selected. -or- Right-click and choose Quick Info from the context menu. The data type of the expression is displayed.

  3. To add a watch expression based on the expression in the Quick Watch dialog box, choose Add.