Public Variable

[mark]

I have a Variable declare in one Sub That I need to use in another Sub.
I tried to declare the variable as public.
But As as soon as I get out of the first sub the variable content disappear.

I tried
_______________________
Public A as Variant
Public B as Variant

Sub first
A= "Fisrt"
End Sub

Sub Second
B = A + ", Second"
End Sub
________________________

Any ideas, I would like the Value of B to be "Fisrt, Second"

Thanks

 

[Tim Ferguson]

Public A as Variant
Public B as Variant

Sub first
A= "Fisrt"
End Sub

Sub Second
B = A + ", Second"
End Sub

first
second
? b
Fisrt, Second


Works for me. Where have you defined this code: you can't put public
declarations in class modules (including behind forms)?

B Wishes


Tim F

 

[mark]

Thanks, that was my problem, I put it elswere and now working