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.

Global value does not retain value when UserForm is hide
 

Alex,

Works fine for me on Excel 2000, XP Pro.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Alex" wrote in message
om...
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.