2003-->2007 require variable declaration

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hi,
my vb editor defined as non require variable declaration.
the same code - in 2003 worked, but in 2007 i got an error related to
variable not defined.if i define it is ok.

do you have any idea what should i do? i have a lot of such cases.(maybe in
2007 there is another flag to define in addition to the require variable
declaration?)
thanks,
 
It is no different in 2007 than in 2003, VBA hasn't really changed, just a
few additions to the object model.

Maybe you have somehow set the default, in Tools>Options>Editor (the Require
Variable Definition box).

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Variable declaration in Excel 2007 3
Declaring Variables 3
Compile Error: Variable Not Defined 4
Function Declarations !!!!!!!!!!!!!!!!!!!!!! 3
Defining public/global variables in more than one place 1
pivot table macro with a filtering variable 3
Can excel objects be defined as global variables 2
Explicit declaration of variables 1

Back
Top