Skip to main content

Option Explicit

Used at script level to force explicit declaration of all variables in that script.


Option Explicit




If used, the Option Explicit statement must appear in a script before any procedures.

When you use the Option Explicit statement, you must explicitly declare all variables using the Dim statement. If you attempt to use an undeclared variable name, an error occurs.


You cannot use Option Explicit inside a method.


The following example illustrates use of the Option Explicit statement:

Option Explicit    ' Force explicit variable declaration.
Dim MyVar          ' Declare variable.
MyInt = 10         ' Undeclared variable generates error.
MyVar = 10         ' Declared variable does not generate error.


Use Option Explicit to avoid incorrectly typing the name of an existing variable or to avoid confusion in code where the scope of the variable is not clear.

FeedbackOpens in a new tab