MS Excel 2016: Check Values in VBA
This Excel tutorial explains how to check values in the VBA debugging environment in Excel 2016 (with screenshots and step-by-step instructions).
See solution in other versions of Excel:
Checking values
In Excel 2016, if you want to view the value of a variable in your VBA code at the time that the program was suspended, you can move your mouse pointer over that VBA code. Bubble text will appear displaying the variable/expression name and its value in its current state.
In this example, we've moved the mouse pointer over the expression pValue. The bubble text displays the expression name with a value of "123xyz".
This feature is useful if you need to quickly check a variable/expression in your code.
Advertisements