Page 77 - Excel for Scientists and Engineers: Numerical Methods
P. 77
54 EXCEL: NUMERICAL METHODS
Figure 2-25. Displaying the value of a variable while in break mode.
Examining the Values of Variables During Execution
You can also display the values of selected variables as the code is executed.
There are several ways to select variables or expressions to be displayed:
Highlight the variable or expression and then choose Quick Watch ...
from the Debug menu or press the Quick Watch button on the
Debug toolbar, to display the Quick Watch dialog box (Figure 2-26).
Highlight the variable or expression and then choose Add Watch ...
from the Debug menu to display the Add Watch dialog box (Figure 2-
27).
Figure 2-26. The VBA Quick Watch dialog box.