Text Documents (Writer)
HTML Documents (Writer Web)
Spreadsheets (Calc)
Presentations (Impress)
Drawings (Draw)
Database Functionality (Base)
Formulae (Math)
Charts and Diagrams
Macros and Scripting
Office Installation
Common Help Topics
OneOffice Logo

Option Compatible Statement

Option Compatible extends Office Basic compiler and runtime, allowing supplemental language constructs to Basic.

This statement must be added before the executable program code in a module.

This option may affect or assist in the following situations:

  • Allow special characters as identifiers. all characters that are defined as letter in the Latin-1 (ISO 8859-1) character set, are accepted as part of identifiers.
  • Create VBA constants including non-printable characters.
  • Allow the New operator to be optional in Dim statements.
  • Allow default values for optional parameters in procedures.
  • Use named arguments when multiple optional parameters exist.
  • Preload of Office Basic libraries

Option Compatible is required when coding class modules.

Syntax:

Option Compatible

Example:

Special characters as identifiers


        Option Compatible
        ' With this option the code works, otherwise it causes a compiling error
        Sub Main
            ä = 10
            print ä
        End Sub
    

Statement Option VBAsupport 1 implies Option Compatible statement automatically.