What is option explicit

Used at the module level to force explicit declaration of all variables in that module. If used, the Option Explicit statement must appear in a module before any procedures. When Option Explicit appears in a module, you must explicitly declare all variables by using the Dim , Private , Public , ReDim , or Static statements.

If the Option Explicit statement had been used, the code wouldn't have compiled, and iVarable would have been highlighted as the cause. You can automatically add the Option Explicit statement to all new modules as follows: Select Options from the Tools menu, select the Editor tab of the Options dialog, then check the "Require Variable Declaration" option in the Code Settings section and click OK.

Skip to main content. Start your free trial. Best Practice — Declare Option Explicit statements at the beginning of your script and then call the script file in the expression. This file may then be shared between modules in multiple transformations. It is more efficient to declare Private variables once in a script file, rather than declaring them in each transformation script. Require variables be declared before they are first used.

Something like this is not easy to spot. Community Bot 1 1 1 silver badge. Matt Wilko Matt Wilko Option Explicit is on by default. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown.

The Overflow Blog. Does ES6 make JavaScript frameworks obsolete? Podcast Do polyglots have an edge when it comes to mastering programming Featured on Meta. Now live: A fully responsive profile. Linked 1. See more linked questions. Related Hot Network Questions. Question feed.