Check out the below link

http://www.contextures.com/xlUserForm01.html

If this post helps click Yes
---------------
Jacob Skaria


"Gazz_85" wrote:

I have created and designed a user form for data entry. How do get it so that
when you click the submit button the data entered in the forms is entered
into the log table and the form is cleared for a new input. also how would i
auto increment an issue number so its the nest in line?

cheers