View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
abc[_6_] abc[_6_] is offline
external usenet poster
 
Posts: 7
Default Retain Variant / String value

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