Word Document Properties

Table 3-1
Compiler Options for VBA
Option
Description
Option Base 
Use this option to change how VBA numbers array 
<Number>
elements. You can number array elements beginning at
0 or 1. In Chapter 9, I describe how to use arrays.
Option Explicit
Smart VBA programmers always add this compiler option
to their code. This option tells VBA that you want to
define variables before you use them. This option not only
makes your code easier to read, but can also help you
find typos in your code. Although the standard setting
treats 
MyVar
and 
MVar
as two variables, this option
forces VBA to question the misspelled version.
Option Compare 
Use this option to change how VBA compares strings. 
<Method>
When you’re using the Binary technique, VBA considers
hello and Hello different because the first form is in low-
ercase. Using the Text method means that VBA considers
hello and Hello as the same word because it doesn’t take
into consideration the case of the letters. The Database
technique, which is available only in Access, uses the
database sort order for string-comparison purposes.
Option Private 
Use this option to make a module private so that no other 
Module
module can see what it contains. The concept of public
and private is the object’s scope. The upcoming section
“Getting the Scoop on Scope” describes in greater detail
what scope means.
The 
Option Explicit
statement is so important that you should always
add it to a program. Listing 3-1 is a short example of how this feature works.
65
Chapter 3: Writing Structured VBA Programs
08_046500 ch03.qxp 12/5/06 5:34 PM Page 65

---

Listing 3-1