MS Excel 2007: Check Values in VBA
This Excel tutorial explains how to check values in the VBA debugging environment in Excel 2007 (with screenshots and step-by-step instructions).
See solution in other versions of Excel:
Checking values
In Excel 2007, 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 Int(pValue). The bubble text displays the expression name with a value of 56.
This feature is useful if you need to quickly check a variable/expression in your code.
Advertisements