Use Quick Watch
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.
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.