View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default Retain Variant / String value

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