Word Document Properties

Chapter 4: Storing and Modifying Information
09_046500 ch04.qxp 12/5/06 5:54 PM Page 105

---

Working with other formatting functions
VBA provides four custom formatting functions: 
FormatNumber
,
FormatDateTime
, 
FormatCurrency
, and 
FormatPercent
. These 
functions don’t do anything that you can’t do with the 
Format
function. The
reasons why some VBA users rely on these functions is that their names make
clearer the purpose of the formatting and using them requires less typing.
All four functions return a string, just like the 
Format
function. The only
input that you must provide is the expression that you want formatted. The
default settings return a formatting string that relies on the regional settings
that the user has set for the computer. You can override these settings by
specifying the optional arguments provided for each function.
Working with Operators
Operators determine how VBA works with two variables and what result it
produces. The examples in this chapter use operators to add numbers and
concatenate
(add) strings. In both cases, your code uses the + operator to
perform the task. However, the result differs. When you’re using numbers,
the result is a summation, such as 
1 + 2 = 3
. When you’re using strings,
the result is a concatenation, such as 
Hello + World = Hello World
.
VBA groups operators into four areas:
Arithmetic:
Operators that perform math operations, such as addition
(
+
), subtraction (
-
), division (
/
), and multiplication (
*
)
Comparison:
Operators such as less than (
<
), greater than (
>
), and
equal (
=
) that compare two values and produce a Boolean result