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.
ManuHuygheAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

NorieVBA ExpertCommented:
You'll have to store the data somewhere and, if required, read it back the next time the workbook is opened.

Writing code to do that might be a major job but shouldn't be too complicated and once it's done, it's done.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ManuHuygheAuthor Commented:
Ok thanks for the reply.

I thought already but was hoping for a miracle ;-)
0
Roy CoxGroup Finance ManagerCommented:
This might help, it saves the entries to the registry and repopulates when next opened
USERFORM-with-Memory.xlsm
1
ManuHuygheAuthor Commented:
Thanks Roy,

It will surely fasten the job.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.