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 Explicit Statement

Specifies that every variable in the program code must be explicitly declared with the Dim statement.

Syntax:

Option Explicit

Parameters:

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

Example:


Option Explicit
Sub ExampleExplicit
Dim sVar As String
    sVar = "Las Vegas"
    For i% = 1 To 10 ' This results in a run-time error
        Rem
    Next i%
End Sub