07-05-2005, 07:05 PM
|
|
|
|
Re: Option Explicit
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
>
|
(at work i am (first -Ima, last Fish,--"Ima Fish")
Linear Mode
