Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Option Explicit
|
|
|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Option Explicit
Resolved · Low Priority · Version 2003
Reply Thu 29 Jan 2009, 16:42Delegate Camilla said...
Camilla has attended:
Excel VBA Intro Intermediate course
Option Explicit
What is the purpose of the "Option Explicit" section at the top of the code editor page?
For upcoming training course dates see: Pricing & availability
RE: Option Explicit
Hi Camilla
By default, VBA doesn't require that you declare your variables using the Dim statement.
If the compiler encounters a name that it doesn't recognize as an existing variable, one of the VBA reserved words, or a property or method, it will create a new variable by that name.
While this may seem convenient, spelling mistakes can lead to bugs in the code that are difficult to find.
Using Option Explicit requires that all variables be declared.
The area where the Option Explicit appears is known as the Declarations area and it is where all Module level and public variables are written.
Hope this helps
Carlos
Reply Tue 3 Feb 2009, 15:50Delegate Camilla said...
RE: Option Explicit
Great, thanks Carlos.
|