View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Shatin[_2_] Shatin[_2_] is offline
external usenet poster
 
Posts: 56
Default Retain Variant / String value

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