Home > Blockchain >  Where goes the undeclared variables in VBA
Where goes the undeclared variables in VBA

Time:02-22

I try to understand what (and how) does some old VBA code.

I have a Sub, and I have a variable that is not declared in that Sub.

The Option Explicit is set to False.

Should I consider that variable a global one? Didn't found that info in the VBA docs...

Sub test1()
    x = "test one"
End Sub

Sub test2()
    x = "test2"
    Call test1
    MsgBox (">'"   x   "'<")
End Sub

enter image description here

there is no way to navigate to the definition of an undeclared variable enter image description here

CodePudding user response:

No, undeclared variables are created local to the method/subroutine. It will be deallocated when you exit the routine. If you reference the same variable name in another routine, it will just create another uninitialized local variable.

  • Related