Public Variable

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
That should work, assuming that you Call first, then Second.

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
Click to expand...


Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher
 
Public A as Variant
Public B as Variant

Sub first
A= "Fisrt"
End Sub

Sub Second
B = A + ", Second"
End Sub
Click to expand...

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
 
Back
Top