Where goes the undeclared variables in VBA

user_961631 0
Viewed 85

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

vba excel
1 Answers

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.

user_1091220
Related