Userform keeps/retains data previously entered when closed and then reopened.

Change this

Please Login or Register  to view this content.

To this:

Please Login or Register  to view this content.

And comment this out:

Please Login or Register  to view this content.

You're welcome.




You may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

The form does not have anything in the fields. Therefore, when you close and re-open the workbook, and reload the form it will be clear.

As has been suggested, you can save and load the field content to/from a worksheet. That would need a different approach to the solution offered.

When you initialise the form, you need to read the value from the sheet. When you close or hide the form, you need to save the current contents of the fields to the sheet.

Ok, I am trying to figure out how I can do this, wondering if code like this will work, but it is not working. Any thoughts?

Please Login or Register  to view this content.

That's not what your form is called. It's UserForm2a

Working code plus some minor tweaks (mostly to tidy up the code)

Please Login or Register  to view this content.

That worked TMS.

Now, is there a way that I can get the VBA code in the userform to automatically update once Sheet1 is copied within the workbook? I put a sheet in here "Test". So ideally once the end user uses the userform on Sheet1, they will copy Sheet1 to a new sheet (in this case it is 'Test'). I then want them to be able to use that userform on both the 'Test' sheet and the 'Sheet1'.

So essentially, I am looking for a way to get the existing VBA code updated when the user copies 'Test' to a new sheet. Is that possible? I have been researching and I have not seen anything that addresses this - workbook is attached!

On your "dump" sheet, you need to create a row for each worksheet, with the sheet name in column A. This can be done pre-emptively or on the fly. If the number and name of the sheets is fairly static, you could do it as a one-off and that would make the coding simpler.

Then, when you load a form on a specific sheet, you can look for the data in the row with that sheet's name. Similarly, when you close the form, you need to write the data to the row with that sheet's name.

I'm guessing you have most of the code for loading and saving the data to/from the form. You just need to tweak it to choose a specific row.

Hello. I don’t quite understand what you want to get as the final result from the form. But suddenly I guessed right, insert the following code into your form:

Please Login or Register  to view this content.

You launch the userform, in the drop-down list "ComboBox16" select the worksheet name in it and the selected worksheet is activated and the controls on the form from the active worksheet are filled in. But then I didn’t understand anything at all, then adjust the code yourself to suit your wishes. Good luck.

...A few moment later...
@Shruder, Thanks for the feedback and added rep point. Good luck.