Use Quick Watch

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.

Community Additions

ADD
Show:
© 2014 Microsoft