While debugging code in the Visual Basic Editor (VBE) , you can see the values of variables and expressions using the Quick Watch feature. Select the variable or expression whose value you want to see and press Shift+F9 to view the Quick Watch dialog.
You can also hover over most variables and expressions to show a tooltip with the value. These are valuable techniques, particularly when you want to see only part a formula. The first example shows the Quick Watch dialog and the second shows the tooltip, both showing the results of part a formula. Note that A1 holds the value 10.