As Harold points out, it is largely up to the designer as to where the data
is stored. If you want ease of recovery, then it would probably be wise to
store it in the same file (workbook)as the UserForm is in. You could use a
sheet that is not used in the other operations of the project and hide it
when not needed. The process would be to copy the data from the UserForm
before closing the form. Hide the sheet. Save the file before closing the
workbook. Then when opening the workbook, unhide the sheet and use the
initialize event of the UserForm to repopulate the form from the data stored
on the sheet. then hide the sheet until you are ready to shut down again.



"Brian" wrote in message
...
I have a User Form that once it is filled in, it updates several other Work
Books from different Control Buttons.

I need to save the Input on the User Form in one of the Wook Books, so
that
if the Work Book is opened again the User Form automatically Fills back
in.

Would the Information on the User Form be saved on a hidden Work Sheet in
the Work Book that I want to save it in?

Any Ideas on how to achive this?