ManuHuyghe
asked on
Excel VBA: Close and reload workbook with userforms
Dear All,
I'm creating a workbook with multiple userforms and the users can only see the userforms and not the excel sheets.
For the moment the workbook can't be closed before they fill in all the necessary userform and when all is filled in then the workbook closes by it self.
I was wondering that there is an easy way to close prematurely a workbook like that (for example when they are half way and don't have the necessary time to finish) and save it as draft. And that this workbook can be open afterwards to continue with all the userforms filled in as before.
Because i supose that when i close a workbook, all userforms are unloaded and i lose all info and because i have multiple userforms with plenty of inputs it will be a major job to wite every single input to a sheet so i can be used afterwards.
Thanks in advance.
I'm creating a workbook with multiple userforms and the users can only see the userforms and not the excel sheets.
For the moment the workbook can't be closed before they fill in all the necessary userform and when all is filled in then the workbook closes by it self.
I was wondering that there is an easy way to close prematurely a workbook like that (for example when they are half way and don't have the necessary time to finish) and save it as draft. And that this workbook can be open afterwards to continue with all the userforms filled in as before.
Because i supose that when i close a workbook, all userforms are unloaded and i lose all info and because i have multiple userforms with plenty of inputs it will be a major job to wite every single input to a sheet so i can be used afterwards.
Thanks in advance.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
This might help, it saves the entries to the registry and repopulates when next opened
USERFORM-with-Memory.xlsm
USERFORM-with-Memory.xlsm
ASKER
Thanks Roy,
It will surely fasten the job.
It will surely fasten the job.
ASKER
I thought already but was hoping for a miracle ;-)