code or macro that would save data then clear form

[Japs]

I have a form built that I would like to ba able to create a database of
saved data from before excuting my clear reset macro.
Example would be:
Transfer data from my form, save on the next available row in another
worksheet then clear form. Any ideas?

 

[Dave Peterson]

I'd start on Debra Dalgleish's site:
http://contextures.com/xlForm02.html

and you didn't ask for this:
http://contextures.com/xlForm03.html