Resetting variables in userform 
Author Message
 Resetting variables in userform

I have created a Userform containig several Textboxes. All works fine,
but when the user calls for this Userform a second time the values of
the previous entries in the Textboxes show. How can I encode that when
hiding a Userform all variables are reset?

Thanks,
Po



Sun, 31 Aug 2003 20:22:50 GMT  
 Resetting variables in userform
If you Unload the userform you will kill that instance. Then the next time
you Show it there will be a new initialized instance.

--
Jim Rech
Excel MVP



Sun, 31 Aug 2003 21:50:02 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Variable(s) Reset by Showing 2nd UserForm on top 1st UserForm

2. Variables- How do I keep a Variable from being reset when closing excel

3. Passing a Variable from one Userform to another Userform

4. Two Questions - Making a userform active / Accessing a userform via a variable

5. Resetting objects in userform

6. Reset a UserForm

7. Resetting userform controls en mass

8. recalling a userform and resetting document

9. Reset or clear variable within a module

10. reset all variables


 
Powered by phpBB® Forum Software © phpBB Group