SEARCH
0-9 A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
Prev | Current Page 27 | Next

Jim DeMarco

"Pro Excel 2007 VBA"


This data is read-only.
Value: Lists the value of the variable. When you click a value in the Value column, the cursor
changes to an I-beam. You can edit a value here to alter your code execution.
nNote All numeric variables must have a value. String variables can have an empty value.
Type: Lists the variable type (read-only).
CHAPTER 1 n THE MACRO RECORDER AND CODE MODULES 12
The Watch Window
The Watch window (Figure 1-16) appears automatically when watch expressions are defined
in the project (Figure 1-17).
Figure 1-16. The Watch window
Figure 1-17. The Watch window takes action when values meet certain criteria.
You can use the Watch window to do the following:
??? Change the size of a column header, by dragging its border to the right to make it larger
or to the left to make it smaller
??? Drag a selected variable to the Immediate window or the Watch window
Close the window by clicking the Close box. If the Close box is not visible, double-click the
Title bar to make the Close box visible, and then click it.
Watch Window Elements
The Watch window list box columns display information about your watched expressions.
Expression: Stores a conditional phrase defined by the developer to evaluate the value of
the watched variable. For example, if you wanted to know when a string variable named
sCity was equal to New York, you would enter an expression of sCity = "New York".
Value: Lists the value of the expression at the time of entering break mode. You can edit
a value here to alter code execution.


Pages:
15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39