Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
De-dup and retain new records only | Excel Worksheet Functions | |||
global changes | Excel Worksheet Functions | |||
Userform.hide / show | Excel Programming | |||
Hide/Show modeless userform when activating/deactivating workbooks | Excel Programming | |||
hide a textbox on a userform? | Excel Programming |