98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Option Explicit
Option Explicit
Resolved · Low Priority · Version 2003
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?
Mon 2 Feb 2009, 10:19Trainer Carlos said...
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
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. |
Excel tip:Repeating headings on spreadsheets that print on more than one pageBy default when you print a spreadsheet out and it prints on more than one page, the headings at the top and the side of the spreadsheet don't appear on all the pages following page 1. |
