How to use Const statement in VBA?

The Const statement in VBA (Visual Basic for Applications) is used to declare and define constants. A constant is a type of variable whose value cannot be changed during the execution of the script. Using constants can make your code more readable and maintainable.

Here’s how to use the Const statement in VBA:

Declaring Constants

Syntax: The basic syntax for declaring a constant is as follows:

Const constantName As DataType = Value


  • constantName is the name of the constant.
  • DataType is the type of data the constant will hold (e.g., Integer, String, Double, etc.).
  • Value is the value assigned to the constant.

Example: Here’s an example of declaring a constant:

Const PI As Double = 3.14159265358979

In this example, PI is a constant of type Double and is assigned the value of Pi.

Using Constants

Once a constant is declared, you can use it throughout your VBA code just like any other variable, but you cannot modify its value.

For instance:

Sub CalculateArea()
    Const PI As Double = 3.14159265358979
    Dim radius As Double
    Dim area As Double

    radius = 5 ' Suppose the radius of a circle is 5
    area = PI * radius ^ 2

    MsgBox "The area of the circle is " & area
End Sub

In this subroutine, PI is used as a constant to calculate the area of a circle. Since PI is a constant, its value remains the same throughout the program, ensuring accuracy and consistency.

Scope of Constants

Local Scope: If you declare a constant within a subroutine or function, it will be local to that subroutine or function.

Global Scope: If you declare a constant at the top of a module, outside of any subroutine or function, it becomes available to all procedures in that module.

Best Practices

Naming Conventions: Constants are typically named using uppercase letters. This makes them easily distinguishable from regular variables.

Usage: Use constants for values that do not change and are used multiple times in your code, such as mathematical constants (like PI), or for values that are used as configuration settings or flags.
Using constants in VBA helps to prevent errors that might occur if a value is inadvertently changed somewhere in the code. It also makes your code easier to read and understand.

Switch the language

Unlock Your Potential


Basic - Advanced


Access Basic - Advanced

Power BI

Power BI Basic - Advanced

Help us grow the project

Leave a Reply

Your email address will not be published. Required fields are marked *