Who uses Option Explicit?

[Fazza]

Option explicit should be the default; I don't know why it isn't.

 

[Jon von der Heyden]

I use Option Explicit all the time. I'm such a graet tpyist that it's worth my while...
Also, once I set the capitalisation in the variable I always type in lower case after that. Helps catch typos...

Denis

And I thought I was being smart! Unfortunately same doesn't work for UDTs, typing in lower converts the type name and all previous references to it to lower case! Grrr!

I hope plenty more participate in the poll. It would be nice to see the stats with a larger sample. Especially like that you have separated advanced, intermediate and new users in the sample, because I have often wondered how many accomplished programmers actually don't force explicit declaration.

 

[erik.van.geit]

Using Option Explicit all the time and to complete the variable names without typos using Ctrl+Spacebar

example
type this

Dim tzhkzjthkjghdlkfgjfhdslgkjdshg As Single 'or whatever
tz

then Ctrl+Spacebar and you'll get the variable at once

kind regards,
Erik

 

[gardnertoo]

I voted Intermediate - No. I know I should use OE, I just forget to. I'll try to do better, I promise!

 

[Smitty]

Just go into the VBE tools and check it. That way you won't need to worry about forgetting.

 

[Norie]

I've got it turned on in all applications where I use VBA.

Mind you I do find myself deleting it quite a lot when all I want to do is some quick testing.

How about compiling?

Do many people just run the code before using Debug>Compile Project?

One handy thing I noticed recently after installing 2010 was that once I'd set Option Explicit on in Excel it was reflected elsewhere.

I thought I'd end up having to set it in each application as I went.

How about IntelliSense?

It's normally pretty handy, for things like completing variable names as Erik pointed out, but I find sometimes I end up declaring Longs as LoadPictureConstants etc..

 

[Jaafar Tribak]

I have the Option Explicit set by default but I tend to temporarly remove it if I am doing some quick testing of code that contains API callbacks to avoid cheerful GPFs.

 

[Sandeep Warrier]

I'm relatively used to always declaring variables (xept for when I'm too lazy ) ... never thought of using Option Explicit .... programmed a bit in C while in college

When I started VBA, I had some accidental "non-declarations" by using

Dim XYZ, ABC, DEF As Integer..... because I thought this would consider all the variables as integers ... cuz I was used to

Int a, b, c etc.... in C

 

[SydneyGeek]

I've got it turned on in all applications where I use VBA.
How about compiling?

Do many people just run the code before using Debug>Compile Project?

That'd be me... I compile once I've made lots of changes, and before setting up the next version of a database on a client machine. Probably should do it more often

One handy thing I noticed recently after installing 2010 was that once I'd set Option Explicit on in Excel it was reflected elsewhere.

I thought I'd end up having to set it in each application as I went.

Haven't used 2010 enough to come across that yet, but I like the idea.

How about IntelliSense?

It's normally pretty handy, for things like completing variable names as Erik pointed out, but I find sometimes I end up declaring Longs as LoadPictureConstants etc..

Yeah, you get some weird datatype declarations with Intelli(non)sense but on the whole I find it useful enough to keep it enabled. I like Erik's shortcut though.

Denis

 

[yytsunamiyy]

Voted intermediate-always. Just as Denis said - I'm too bad a typist not to rely on the capitalisation trick, and I had a few nasty surprises with undeclared variables. Variant data type doesn't always give you what you'd expect to get.