Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Re-Populating Previous Answers into a User Form from the Spreadshe
same why they were written there, just in reverse
Textbox1.Text = Worksheets("Data").Cells(rw,1) Combobox1.Value = worksheets("Data").Cells(rw,1) the value of rw would have to be determined. Much beyond that would require greater knowledge of what the userform looks like and how you determine previous answer. The above assumes the Userform shows 1 record/1 row at a time. -- Regards, Tom Ogilvy "WillRn" wrote in message ... I have a user form by which people submit data to a large spread sheet. After the user completes the form, it is saved locally to their hard drive and then e-mailed to me. Is there a way in which the previous answers from the spreadsheet can be pulled into a blank userform? I envision a command button at the bottom of the form saying "Retrieve Previous Answers?" After the User tells the computer which spreadsheet to access, all the previous entries would be pulled back to the userform. Any ideas on how to do this? Thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Populating a form | Excel Worksheet Functions | |||
Form. to ignore cells w/o value from calc from previous Form. | Excel Worksheet Functions | |||
conditional formulas based on form answers (yes, no checkboxes) | Excel Discussion (Misc queries) | |||
how do i create form of yes/no answers for mass e-mail sending | Excel Worksheet Functions | |||
A "previous" button on a user form | Excel Discussion (Misc queries) |