Dim VBA – Declare Variable

Written by

Editorial Team

Reviewed by

Steve Rynearson

Last updated on July 19, 2021

The Dim Keyword in VBA

You can use the Dim keyword in order to declare a variable in VBA:

Dim n as Integer

Dim stands for Dimension. When you use the Dim keyword, state the name and data type of the new variable.

This is shown in the code below:

Sub DeclaringAVariableUsingDim()

Dim productName as String
Dim myNumber as Integer
Dim myRange as Range
Dim wb as Worksheet
Dim myValue as Boolean

End Sub

We have declared five different variables in the above code, and used five different data types. You can learn more about how to name variables and variable data types in our VBA Data Types – Variables and Constants tutorial where we go into detail about what variables are, how to name them and the different data types available in VBA.

VBA Coding Made Easy

Stop searching for VBA code online. Learn more about AutoMacro - A VBA Code Builder that allows beginners to code procedures from scratch with minimal coding knowledge and with many time-saving features for all users! vba save as

Learn More!

VBA Code Examples Add-in

Easily access all of the code examples found on our site.

Simply navigate to the menu, click, and the code will be inserted directly into your module. .xlam add-in.

(No installation required!)

Free Download

Return to VBA Code Examples