Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Where goes the undeclared variables in VBA

Tags:

excel

vba

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

like image 996
serge Avatar asked Oct 23 '25 16:10

serge


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.

like image 82
RBarryYoung Avatar answered Oct 26 '25 09:10

RBarryYoung



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!