- Declaring Variables
- Avoiding Variable Errors
- Variable Data Types
- Using Array Variables
- Working with Constants
- The Absolute Minimum
This chapter is from the book
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