Save & Retrieve data to userforms
Posted by Ron on June 06, 2001 7:38 AM
I'm looking for a suggestion..........
I have a group of userforms that collect 80-100 pieces of data, perform calculations, and place the caluclated data onto sheets to be printed as reports. When the workbook is saved, the userforms are cleared when the workbook is reopened. I would like to be able to save the data entered and repopulate the userforms when the workbook is reopened so the user may make a change or two without entering all the data again.
Any ideas??? Thanks.