Thread: option explicit
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Kevin B Kevin B is offline
external usenet poster
 
Posts: 1,316
Default option explicit

Option explicit forces the user to declare variables before the variable can
be used.

In the VB Editor (Alt + F11) click TOOLS in the menu and select OPTIONS.
Click the EDITOR tab and then click the REQUIRE VARIABLE DECLARATION check
box to turn OPTION EXPLICIT on.
--
Kevin Backmann


"Dave F" wrote:

Hi,

Two quick questions about 'option explicit.'

1) What does it do?

2) How do I configure VBE to automatically set option explicit?

I know it has something to do with declaring variables, but I don't know why
it's important. Thanks,

Dave
--
Brevity is the soul of wit.