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.
   72   73   74   75   76   77   78   79   80   81   82