Master the use of variables in your Visual Basic for Applications (VBA) procedures

Visual Basic for Applications (VBA) procedures often need to store temporary values for use in statements and calculations that come later in the code. Although you may get away with using the underlying application to store these values, this almost always isn't practical. Instead, VBA (like all programming languages) lets you store temporary values in special memory locations called variables. In this sample chapter from VBA for the 2007 Microsoft Office System, explore variables and learn how to use them in your VBA procedures. Chapter coverage includes:

• Declaring variables
• Avoiding variable errors
• Understanding variable data types
• Using array variables
• Working with constants
• Storing user input in a variable

Title: VBA for the 2007 Microsoft Office System
ISBN: 0-7897-3667-5
Published: March 2007
Authors: Paul McFedries
Chapter: Chapter 3: Understanding Program Variables
Published by Que Publishing