Variables and Constants in Excel Visual Basic
Part one of an eight-part series of blogs

This blog explains the nuts and bolts of Excel VBA variables, including how to declare them, how to set their scope and all sorts of other tips and tricks. The blog also covers constants in Excel macros.

  1. Variables in Excel Visual Basic macros (this blog)
  2. What is a Variable? VBA macro variables.
  3. Declaring Variables in Visual Basic for Applications
  4. Using Variables (Assigning and Retrieving Values)
  5. Forcing Declaration of Variables (Option Explicit)
  6. Useful Things to Know about Variables
  7. The Scope of Variables
  8. Constants in Excel Visual Basic for Applications

This blog is part of our Excel macros online tutorial series.  Alternatively, we run training courses in the UK in Excel and also in Visual Basic for Applications (and are always looking for partners in the US or other English-language countries!).

Posted by Andy Brown on 05 September 2011

You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

Variables in Excel VBA Macros

This blog introduces and explains the concept of variables.  Our example is to do with the following spreadsheet:

Superhero form

When you fill in the name of your superhero and give him (or her) a rating, you can then click on the button to run a macro to record this vote.


When you click on the RECORD VOTE button shown above, Excel will add it to the list of votes:

Votes cast report

The list of votes cast so far.


With this example in mind, let's first find out what a variable actually is.


This blog has 0 threads Add post