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,