Dear all

I am new in vba and vb. I found that the store value of a variant or string
will change back to zero after jump to other sub or private sub. How can I
retain the store value even the program proceed to other sub or private sub?

Thanks

abc,
You need to read up about "Scope" of variables.
Also, understand how parameters to functions/subs work.

NickHK

"abc" wrote in message
...
Dear all

I am new in vba and vb. I found that the store value of a variant or
string
will change back to zero after jump to other sub or private sub. How can I
retain the store value even the program proceed to other sub or private
sub?

Thanks

You can declare a static variable:

Static x as string

"abc" wrote in message
...
Dear all

I am new in vba and vb. I found that the store value of a variant or
string
will change back to zero after jump to other sub or private sub. How can I
retain the store value even the program proceed to other sub or private
sub?

Thanks

thanks to all!

"Shatin" ¦b¶l¥ó
¤¤¼¶¼g...
You can declare a static variable:

Static x as string

"abc" wrote in message
...
Dear all

I am new in vba and vb. I found that the store value of a variant or
string
will change back to zero after jump to other sub or private sub. How can
I
retain the store value even the program proceed to other sub or private
sub?

Thanks