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

option explicit possible problem

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Option Explicit possible problem

Option Explicit possible problem

ResolvedVersion 2003

Robert has attended:
Excel VBA Intro Intermediate course

Option Explicit possible problem

When writing code in today's course Option Explicit even though on did not seem to stop non existent variables being used.

Is this a problem of the machines used or is it a wider problem.

RE: Option Explicit possible problem

Hi Bob, thanks for your query. We are still investigating this and believe it to be a consequence of running two versions of Excel on the same machine. Some misspelt variables appear to be declared as variants when they should be trapped by Option Explicit. We believe this to be a problem for us on our training machines rather than an application error but if you spot it happening elsewhere let us know on the forum.

All the best,

Anthony

Tue 8 Feb 2011: Automatically marked as resolved.

 

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:

Customize the toolbar in Excel 2010

You can create your own toolbar which contains your favourite or most used tools. This will make using Excel much more efficient. To do this, you need to click on View, then select Customize Quick access Toolbars and then select Customize. A list of tools will then appear on the screen of which you can add or remove them as you please.

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.