Userform Hide and Save

**gsurge** · 06-02-2011, 09:58 AM

Hello,

I created a "pause" button on my userform that allows the user to temporarily stop filling out the form and resume at a later time. The issue I am having is that when the user saves and closes the excel file, and reopens it, the data is lost on the userform.

The pause button runs off of a userform.hide command, and works when the file remains open. Is there another way of managing this capability, while ensuring the patially completed userform saves the information until the user completes and submits the data?

Thanks
GSurge

**royUK** · 06-02-2011, 10:12 AM

You can't save a userform's input when the workbook is closed. The input must be saved to say a hidden sheet & retreived when re-opening

**Charles** · 06-02-2011, 10:12 AM

Hi,

When you close Excel it will clear the userform info. What you need to do is when you Click the "Pauses" button to have the info stored some where and then if you close Excel and reopen it you can have the form reload the info.

**gsurge** · 06-02-2011, 10:39 AM

Great. Can you please help me the code for that?

Do you have an example of how the code should look? I am very new at VBA....

**Charles** · 06-02-2011, 10:48 AM

Hi,

The code would be similar to your code(if you have it) that when you want the data to be transferred from the form to the worksheet. The only difference is it will go to a hidden sheet.
And when you re open Excel you will have the userform initialize (filed in) when the form is call up to be used.

**gsurge** · 06-02-2011, 11:07 AM

I understand the transfer to the hidden worksheet, but could you provide an example/further explanation of how to get the data back into the userform when the form is restarted after excel is opened?