Make data stay on userform

Posted by Steve W on April 30, 2001 6:55 AM

Does anyone out there know how I can make data that a user inputs on a userform stay there the next time the form is opened.
Thats steve

Posted by Dave Hawley on April 30, 2001 7:00 AM

Hi Steve

If you simply Hide the UserForm, ie; Me.Hide
as apposed to Unloading it ie; Unload Me
All values entered will be retained. Of course if you want the values to be still there after closing the Workbook and re-opening, you will need to store all Values on a hidden Worksheet and use the Initialize Event of the UserForm to populate the Controls

Dave

OzGrid Business Applications

Posted by steve w on April 30, 2001 8:44 AM