Option Statements | VBAReference

As in other BASIC programming languages, CitectVBA supports the declaration of variables both implicitly and explicitly. An unfortunate consequence of implicit variable declaration is the possible misspelling of the variable name in subsequent code writing, with unreliable program behaviour and unpredictable consequences.

To minimize implicit declaration, and to foster good, consistent programming standards, use the option explicit statement at the beginning of all your CitectVBA files:

Option Explicit

This causes the CitectVBA compiler to produce a compile error whenever it encounters an undeclared variable. This can be useful in locating and identifying variable name typing errors in your CitectVBA code at compile time, thus trapping and minimizing the likelihood of runtime errors caused by such mistakes.

Option Compare Statement

The Option Comparestatement determines how strings are compared within a CitectVBA file, and like other Optionstatements in CitectVBA, should be declared at the beginning of your CitectVBA code files.

When strings are compared using CitectVBA functions such as StrComp()or InStr(), CitectVBA determines whether they contain equivalent characters and how they differ if they do not match.

Note: When comparing strings, CitectVBA compares the ANSI values of each character in the strings. For example, the character capital 'A' has the ANSI value of 65, and the character lowercase 'a' has the ANSI value of 97. For a listing of ANSI character values, see ASCII/ANSI Character Code Listings.

You can use the Option Comparestatement to specify the default case-sensitivity behavior for CitectVBA functions when making string comparisons.

The Option Comparestatement in CitectVBA has two settings:

Option Compare Binary: String comparisons are case-sensitive, and this is the default string-comparison setting.
Option Compare Text: String comparisons are case-insensitive.

Option Base Statement

The Option Basestatement determines the default base number for the indexing of variable arrays created within a CitectVBA file, and like other Optionstatements in CitectVBA, should be declared at the beginning of your CitectVBA code files.

There are two settings for the Option Basestatement in CitectVBA:

Option Base 0: Variable arrays are indexed from number zero, and this is the default setting.
Option Base 1: Variable arrays are indexed from number one.

For an example of using the Option Base statement, see Fixed Size Arrays