Mastering VBA for Microsoft Office 2007, 2nd Edition

Chapter 6

Working with Variables, Constants, and Enumerations

This chapter covers the basics of working with variables, constants, and enumerations. Variables provide a way of storing and manipulating information derived from a procedure and include String variables for storing text, various numeric data types for storing numbers (for example, Integer variables for storing integer values), Date variables for storing dates and time, Boolean variables for storing True/False values, and Object variables for storing objects.

A constant is a named item that stores a value that doesn’t change. Constants, like variables, exist only while a program is executing. An enumeration is a predefined list of unique integers that have individual names and meanings ...