Mastering VBA for Microsoft Office 2016

Chapter 6Working with Variables, Constants, and Enumerations

This chapter covers the basics of working with variables, constants, and enumerations. Variables are used often in programming—they provide a way of storing and manipulating information. Variables come in several types, such as 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 even 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. Most programmers rarely create their own constants; ...