Word Document Properties

Concatenation:
Operators such as 
&
and 
+
that are used to add two
strings together
Logical:
Operators such as 
Not
, 
And
, 
Or
, and 
Xor
that are used to per-
form Boolean operations on two variables
The Operator Summary help topic explains in detail each of these operator
categories and the associated operators. The examples in this book demon-
strate how to use the various operators, such as the 
+
(plus) operator, shown
in Listing 4-15.
VBA also assigns operators a 
precedence,
or order of use. When your code
contains the equation 
MyVal = 1 + 2 * 3
, VBA performs the multiplica-
tion first and then the addition to receive a value of 
7
because multiplication
has a higher precedence than addition. However, the equation 
MyVal = (1
+ 2) * 3
has a result of 
9
because parentheses have a higher precedence
106
Part II: Learning the Ropes 
09_046500 ch04.qxp 12/5/06 5:54 PM Page 106

---

than multiplication. The rules that VBA uses for precedence are the same
rules that you learned in math class. See the Operator Precedence help topic
for more information.
Applying What You Know to 
Design an Excel Report
All the examples up to this point in the book have worked with abstract (or
demonstration) code. 
Abstract code
is practical for presenting concepts, but
you wouldn’t actually add it to a document because it doesn’t perform useful
work. The reason that you use VBA is to accomplish useful work.
The example in this section relies on code to create an Excel report. You
begin by typing the entries shown in Figure 4-5. These entries serve as a 
basis for the report.
The report contains data entries. It also has a summary when the code exe-
cutes. Listing 4-17 provides the code to use.