Retaining values on multiple VBA forms.
Posted by Ron on May 08, 2001 4:50 PM
I have multiple VBA forms that collect date and insert the data into a number of sheets that are used as reports.
I would like to know if anyone knows of a way to keep the data entered on each form intact while hiding and showing the various forms. The problem I'm having is the user fills out some textboxes on form A and goes to form B. But if the user returns to form A through code which hides and shows the forms, the textbox is empty.
Any ideas appreciated!