VBA: Understanding Variables

Variables are used to store values that you use in Visual Basic for Applications (VBA), actually any programming language uses variables. They can store values such as numbers, dates, strings (text) or objects.

Here in this tutorial you will get an overview of how variables work and an example of how to use them in Excel VBA, although the same principles apply to using in other Office applications such as Microsoft Access, Word, PowerPoint, MS Project etc.