Option Explicit Statement

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

Syntax:

Option Explicit

Parameters:

warning

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

Please support us!