Chapter 24: Mastering VBA Data Types and Procedures
IN THIS CHAPTER
Naming and declaring variables
Looking at the VBA data types
Understanding the scope and lifetime of variables
Looking at arrays
Working with subs and functions
All VBA applications require variables to hold data while the program executes. Variables are like a white board where important information can be temporarily written and read later on by the program. For example, when a user inputs a value on a form, you'll most often use a variable to temporarily hold the value until it can be permanently stored in the database or printed on a report. Simply put, a variable is the name you've assigned to a particular bit of data in your application. In more technical terms, a variable is a named area in memory used to store values during program execution.
Variables are transient and do not persist after an application stops running. And, as you'll read in the “Understanding variable scope and lifetime” section, later in this chapter, a variable may last a very short time as the program executes or may exist as long as the application is running.
In most cases, you assign a specific data type to each of the variables in your applications. For example, you may create a string variable to hold text data such as names or descriptions. A currency variable, on the other hand, is meant to contain values representing monetary amounts. You shouldn't try to assign a text value to a currency ...