Option Definition
Syntax
Option Base [0|1] -or- Option Compare [Binary | Text] -or- Option Explicit -or- Option UsesAmbiguousError [On | Off]
Group
Description
Option Base: Set the default base index for array declarations. Affects Dim, Static, Private, Public and ReDim. Does not affect Array, ParamArray or arrays declare in a Type. Option Base 0 is the default.
Option Compare: Set the default comparison mode for <, <=, =, >, >=, <>, Like and StrComp.
- Option Compare Binary - compare string text using binary data (default)
- Option Compare Text - compare string text using the collation rules
Option Explicit: Require all variables to be declared prior to use. Variables are declared using Dim, Private, Public, Static or as a parameter of Sub, Function or Property blocks.
Option UsesAmbiguousError On: When an unqualified symbol not defined in the current macro/module and it is defined in more than one '#Uses module an "Ambiguous name" error occurs. (This is the default.) Turning off this error allows the "first" matching symbol in a '#Uses module to be matched. The '#Uses providing the "first" matching symbol is implementation dependent and not predictable.
Option Base 1 Option Explicit Sub Main Dim A Dim C(2) ' same as Dim C(1 To 2) Dim D(0 To 2) A = 1 B = 2 ' B has not been declared End Sub