Table of contents
TOC
Collapse the table of content
Expand the table of content

Option Explicit Statement

office 365 dev account|Last Updated: 6/12/2017
|
1 Contributor

Used at module level to force explicit declaration of allvariables in thatmodule.

Syntax

Option Explicit

Remarks If used, the OptionExplicit statement must appear in a module before anyprocedures. When Option Explicit appears in a module, you must explicitly declare all variables using the Dim, Private, Public, ReDim, or Static statements. If you attempt to use an undeclared variable name, an error occurs atcompile time. If you don't use the Option Explicit statement, all undeclared variables are of Variant type unless the default type is otherwise specified with a Deftype statement.

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

Example

This example uses the Option Explicit statement to force explicit declaration of all variables. Attempting to use an undeclared variable causes an error at compile time. The Option Explicit statement is used at the module level only.

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