Use Quick Watch
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 by using the Quick Watch command.
To display a Quick Watch
Select an expression in the module where it resides.
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.
To add a watch expression based on the expression in the Quick Watch dialog box, choose Add.
See also
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.