Does VBA Lose Variable Definitions and/or Values between Subs?

[Kenneth Hobs]

Variables are private unless you make the Public outside of a Sub or Dim outside of Sub.

Undefined variables are sometimes mistaken due to spelling errors. Other times, if not set as another part expects, it will show a problem.

e.g.
[VBA]
Public s as String
Sub t
s="Hello World!"
tt
End Sub

Sub tt
MsgBox s
End Sub
[/VBA]

[RonMcK]

Variables are private unless you make the Public outside of a Sub or Dim outside of Sub.

Undefined variables are sometimes mistaken due to spelling errors. Other times, if not set as another part expects, it will show a problem.

DOH! I've either lost too many brain cells or had a brain fart. Thanks, Kenneth for pointing that out. Instead of DIMing, I need to be PUBLICing the variables that are shared.

This makes sense. Is a public variable visible inside a Function or just in Subs?

Thanks,