Implied Option Explicit in XP??

  • Thread starter Thread starter Trip
  • Start date Start date
T

Trip

Hello all,

Quick question here. It seems as though XP is enforcing "Option Explicit"
even though I don't issue this command anywhere in my VBA code. The code
runs fine in other versions of Excel, but in XP it hangs anywhere I have not
explicitly defined a variable's type. Does anyone know why and/or what's
going on? Any direction would be greatly appreciated.

Thanks!

Trip
 
In the VB Editor, is the "Tools->Options->Editor" "Require Variable
Declaration" selected?
Don't know if this would be your problem, but it seems related.
--
Regards;
Rob

Please reply to the NG, I'm already up to my eyeballs in Nigerian/South
African get rich letters
as well as "Microsoft Critical Updates" et al.
 
Look elsewhere for the problem, XP does not default to Option Explicit.

If in the VBA editor you check
Tools|Options|Require Variable Declaration
then Option Explicit will be added to each new module, but it will be
explicitly there, not implicitly required.

Jerry
 
Back
Top