ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   2003--2007 require variable declaration (https://www.excelbanter.com/excel-programming/394944-2003-2007-require-variable-declaration.html)

Miri

2003--2007 require variable declaration
 
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,
--
Miri Tz.

Bob Phillips

2003--2007 require variable declaration
 
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 ToolsOptionsEditor (the Require
Variable Definition box).

--
HTH

Bob

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

"Miri" wrote in message
...
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,
--
Miri Tz.





All times are GMT +1. The time now is 02:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com