Retrieving previously entered userform data from saved spreadsheet

[Guest]

I have created an "online" form for my managers to use to send me data via an
e-mailed spread sheet. There are about 60 questions that they answer on this
multipage userform. A dialog form at the end saves the data they entered
locally on their C drive, then sends the worksheet with the info they entered
to me as an e-mail attachment.

I was wanting to create a dialog form/command button that could re-populate
the userform with answers from previous entries or saved forms. This could
allow them to submit changes or correct mistakes more easily.

Being relatively new to programming, I have no idea where to start on this
one. I envision a command button on the first page of the multipage that
would ask them which file they would like to pull their old answers from and
then re-populate the old userform for review. Or they can just enter new
information if they wish.

Any ideas?

WillRn

 

[Guest]

Hi WillRn,
If i understand correctly, you want users to be able to save each form data,
not just 1 single default profile, isn't it?

If not, ie you try to save a single default form profile, you can use the
registry with the GetSettings and SaveSettings functions to hold/read/save
form default answers for a user.

If so, ie each form could be saved individually and re-loaded if necessary.
Save the data in a single excel sheet in database-list style: each row is a
userform data, ie a list of 60 fields. It would be hidden from the user.
Each userform is given a name by the user, so you have a Name textbox. It
would go in, say, column A of the data sheet.
On your form, you would have buttons:
- Open: to open an existing one. Eg: would display a list or combobox of all
existing names (column A) for the user to pick from.
- Save: add the form data to the data sheet (one new row). Make sure the
name doesn't already exist (in column A)?
- New: to create a new one.

Is that what you are looking for?
Regards,
Sébastien