Home > Articles

  • Print
  • + Share This
This chapter is from the book

This chapter is from the book

Working with Constants

Constants are values that don't change. They can be numbers, strings, or other values, but, unlike variables, they keep their values throughout your code. VBA recognizes two types of constants: built-in and user-defined.

Using Built-In Constants

Many properties and methods have their own predefined constants. For Excel objects, these constants begin with the letters xl. For Word objects, the constants begin with wd. For VBA objects, the constants begin with vb.

For example, Excel's Window object has a WindowState property that recognizes three built-in constants: xlNormal (to set a window in its normal state), xlMaximized (to maximize a window), and xlMinimized (to minimize a window). To maximize the active window, for example, you would use the following statement:

ActiveWindow.WindowState = xlMaximized

Creating User-Defined Constants

To create your own constants, use the Const statement:

Const CONSTANTNAME [As type] = expression

CONSTANTNAME

The name of the constant. Most programmers use all-uppercase names for constants.

As type

Use this optional expression to assign a data type to the constant.

expression

The value (or a formula that returns a value) that you want to use for the constant.

For example, the following statement creates a constant named DISCOUNT and assigns it the value 0.4:

Const DISCOUNT = 0. 4
  • + Share This
  • 🔖 Save To Your Account