Excel 2007 VBA Programming with XML and ASP

Chapter 4Chapter 4

Using Variables,

Data Types, and

Constants

Saving Results of VBA Statements + What Are Vari-

ables? + Data Types + How to Create Variables + How

to Declare Variables + Specifying the Data Type of a

Variable + Assigning Values to Variables + Forcing

Declaration of Variables + Understanding the Scope of

Variables + Procedure-Level (Local) Variables + Mod-

ule-Level Variables + Project-Level Variables + Lifetime

of Variables + Understanding and Using Static Vari-

ables + Declaring and Using Object Variables + Using

Specific Object Variables + Finding a Variable Definition

+ Using Constants in VBA Procedures + Built-in Con-

stants + Chapter ...