Compiler Options, Runtime Conditions
Compiler options specified at the module level affect Office Basic compiler checks and error messages. Basic syntax as well as Basic set of instructions can be different according to the options that are in use. The less Option, the easiest and tolerant Office Basic language is. The more Option, the richer and controlled Basic language gets.
Compiler options must be specified before the executable program code in a module.
Syntax:
Option Base Statement
Defines the default lower boundary for arrays as 0 or 1.
Option ClassModule Statement
Specifies that the module is a class module that contains members, properties, procedures and functions.
Option Compatible Statement
Option Compatible extends Office Basic compiler and runtime, allowing supplemental language constructs to Basic.
CompatibilityMode() Function
CompatibilityMode() function controls or queries runtime mode. It affects all code executed after setting or resetting the runtime mode.
Option Explicit Statement
Specifies that every variable in the program code must be explicitly declared with the Dim statement.
Option Private Module
Specifies that the scope of the module is that of the Basic library it belongs to.
Option VBASupport Statement
Specifies that Office Basic will support some VBA statements, functions and objects.
Options specified at the module level also affect Office Basic runtime conditions. The behaviour of Office Basic instructions can differ.