Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 620
Default 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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
De-dup and retain new records only jaltsman Excel Worksheet Functions 0 June 13th 08 03:11 AM
global changes Eclaires Excel Worksheet Functions 2 March 17th 08 01:03 PM
Userform.hide / show papou[_7_] Excel Programming 0 September 15th 03 03:12 PM
Hide/Show modeless userform when activating/deactivating workbooks Jeremy Gollehon[_2_] Excel Programming 0 August 28th 03 11:05 PM
hide a textbox on a userform? Bill Lunney Excel Programming 2 July 31st 03 08:57 AM


All times are GMT +1. The time now is 08:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"