Scope and lifetime of variables

[tiredofit]

My understanding of a variable's lifetime is that if it is declared at the module level, it retains its vaue, even after the sub has finished running.


So in my following code, after first running Test1 to the end, if I run Test2, the messagebox shows the value of 10, as expected.

Dim a As Integer


Sub Test1


    a = 10


    Msgbox a


End Sub


Sub Test2


    Msgbox a


End Sub

What I don't understand is if I run Test1 through to the end, then type:

? a

in the Immediate window, I get a blank value.


I thought the variable "retains" its value even after Test1 has finished running?


Thanks

 

[RoryA]

Isn’t this exactly the same thing you asked here?

 

[tiredofit]

Thanks, I forgot all about it.