View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Alex[_15_] Alex[_15_] is offline
external usenet poster
 
Posts: 1
Default Global value does not retain value when UserForm is hide

Hi

I have one class, clsTest.
Global value is declared in module, declared as "Public temp as New
clsTest".
When i init the object temp in Userform1, with a value.

This value will not be retained when i call from Userform2, when i
close Userform1 by .hide.

But surprisingly, value is retained when i close the form with "x"
button in Userform1.

Is this a known issues ?

Alex
ps : I'm using Excel 97, at W2k prof.