For a great tutorial on how to do this - goto:
http://www.contextures.com/xlUserForm01.html

HTH,
Jim May

"Lynn" wrote:

I want to be able to open an Excel file so that it goes through a series of
text box forms which need to have data entered into them, which then puts the
info into the spreadsheet. I've seen this done, but don't know how to? How
do I create the text boxes with the questions (and then room for the answers)
and then put them into a spreadsheet? Please!