Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

option explicit

ResolvedVersion 2003

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?

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

RE: Option Explicit

Great, thanks Carlos.

 

Training courses

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Excel tip:

Closing Multiple Workbooks quickly

When you have several workbooks open in Excel and want to just close them all at once:

1) Hold down the SHIFT key before selecting the File menu.

2) Once in File menu release SHIFT key and select Close All option.

3) All your files will close. If files require saving Excel will ask if you want to save the changes.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.