Option Explicit Statement

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

Syntaks

Option Explicit

Parameter

Advarselsikon

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


Eksempel:

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