Take a look at how Debra Dalgleish approached it:
http://www.contextures.com/xlUserForm01.html

michaelberrier wrote:

What is the syntax for putting text entered in a userform(or cell or
whatever) into the next available row in a sheet, so that it forms a
database of sorts?

Thanks to all.

--

Dave Peterson