Sounds like you are going to be sitting in the booth anyway, either way.

Haven't really looked at it but I think Martin Green's user forms
course material would help. Overall view looks like it would cover everything
you can download Spreadsheet and a PDF (or word) document.
http://www.fontstuff.com/downloads/index.htm#excelvba

Other tutorials on for Excel then VBA beginning at
http://www.mvps.org/dmcritchie//exce....htm#tutorials
http://www.mvps.org/dmcritchie//exce...m#vbatutorials
but that was the only one I've listed as for forms.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Marcia3641" wrote in message ...
Hi:
I am trying to create a database of people that attended my mortgage
seminar. But instead of giving them a 4x6 piece of paper to write their
information on, I will have my laptop at the booth and have them fill out the
information that is created in an excel form. It's just to hard to read
people's handwriting these days. I am trying to create a form that once
someone's fills it out their information will automatically go to another
part of the worksheet. But what I don't know how to do is get rid of the
previous person's information before the next person fills it out. I would
like to have some sort of submit but at the end which would then clear the
form, is that possible?
--
Marcia3641