If you've already got the data going to another worksheet, then clearing the
form should be easy.
Just select all the cells you want to clear, hit Insert--Name--Define and
type clearme (or similar), and then record a macro fo yourself hitting
Edit--Go to--Clearme, and hitting your delete key and then go to some nice
landing cell.
http://www.officearticles.com/excel/...soft_excel.htm

*******************
~Anne Troy

www.OfficeArticles.com


"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