Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Retrieving previously entered userform data from saved spreadsheet
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Retrieving previously entered userform data from saved spreadsheet
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 "WillRn" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I delete an already previously saved Excel spreadsheet? | Excel Worksheet Functions | |||
Can i get a previously saved version of an excel spreadsheet? | Excel Discussion (Misc queries) | |||
how can i re-populate a userform with data already entered? | New Users to Excel | |||
how do i revert to previously saved program? | Excel Discussion (Misc queries) | |||
IS THERE ANYWAY TO RETRIEVE A PREVIOUSLY SAVED FILE ONCE IT HAS B. | Excel Discussion (Misc queries) |