LinkBack URL
About LinkBacks
Hi,
Would someone please explain to me the "Option Explicit" phrase.
What does it do?
When should you use it?
Etc
Thx
Dave
Hi,
Would someone please explain to me the "Option Explicit" phrase.
What does it do?
When should you use it?
Etc
Thx
Dave
Try this, fish:
http://www.vbaexpress.com/forum/arti...ticle&artid=40
*******************
~Anne Troy
www.OfficeArticles.com
www.MyExpertsOnline.com
"Piranha" <Piranha.1rpvqf_1120601153.6003@excelforum-nospam.com> wrote in
message news:Piranha.1rpvqf_1120601153.6003@excelforum-nospam.com...
>
> Hi,
>
> Would someone please explain to me the "Option Explicit" phrase.
>
> What does it do?
> When should you use it?
> Etc
>
> Thx
> Dave
>
>
> --
> Piranha
> ------------------------------------------------------------------------
> Piranha's Profile:
http://www.excelforum.com/member.php...o&userid=20435
> View this thread: http://www.excelforum.com/showthread...hreadid=384692
>
It forces you to declare every variable you use in that module.
You should use it in every module that you have.
When this doesn't work like it should
myCtr1 = myCtrl + 1
(one of those has an ELL and one has a ONE)
It really makes debugging easier.
Piranha wrote:
>
> Hi,
>
> Would someone please explain to me the "Option Explicit" phrase.
>
> What does it do?
> When should you use it?
> Etc
>
> Thx
> Dave
>
> --
> Piranha
> ------------------------------------------------------------------------
> Piranha's Profile: http://www.excelforum.com/member.php...o&userid=20435
> View this thread: http://www.excelforum.com/showthread...hreadid=384692
--
Dave Peterson
First, you should ALWAYS use it.
What it does it is to force you to explicitly declare your variables. If
you fail to declare them, then you will get a compilation error.
The advantage of using it is that you won't then make the mistake of
mis-spelling (even slightly) variable names deep in the code, as the
compiler will flag it.
You can use the VB IDE to help you by automatically installing this line in
your modules. To do this, in the VB IDE, go to Tools>Options>Editor, and
check the 'Require Variable Declaration' checkbox.
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Piranha" <Piranha.1rpvqf_1120601153.6003@excelforum-nospam.com> wrote in
message news:Piranha.1rpvqf_1120601153.6003@excelforum-nospam.com...
>
> Hi,
>
> Would someone please explain to me the "Option Explicit" phrase.
>
> What does it do?
> When should you use it?
> Etc
>
> Thx
> Dave
>
>
> --
> Piranha
> ------------------------------------------------------------------------
> Piranha's Profile:
http://www.excelforum.com/member.php...o&userid=20435
> View this thread: http://www.excelforum.com/showthread...hreadid=384692
>
See http://www.cpearson.com/excel/variables.htm for details.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"Piranha" <Piranha.1rpvqf_1120601153.6003@excelforum-nospam.com>
wrote in message
news:Piranha.1rpvqf_1120601153.6003@excelforum-nospam.com...
>
> Hi,
>
> Would someone please explain to me the "Option Explicit"
> phrase.
>
> What does it do?
> When should you use it?
> Etc
>
> Thx
> Dave
>
>
> --
> Piranha
> ------------------------------------------------------------------------
> Piranha's Profile:
> http://www.excelforum.com/member.php...o&userid=20435
> View this thread:
> http://www.excelforum.com/showthread...hreadid=384692
>
Hi,
I don't know how to quote the entire thread so i picked on Anne.
Anne-yes fish(at work i am (first -Ima, last Fish,--"Ima Fish")
Dave
Bob
Chip
You guys are wonderfull. Thx for the great info and links.
Now i am trying to soak it up into my brain.
Thx Very Much for your responces
Dave
Originally Posted by Anne Troy
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks