Hello All,

I am new to building forms in excel and right now its all confusing. Attached I have a work sheet layout out as a starting point.

I have a form with 4 header sections:

Cell A1: Date (Date Worked):
Cell B1: Member ID Number:
Cell C1: Work Type:
Cell D1: Error:

And each header has a form field aligned under it:

Cell A2: Calendar Date Picker
Cell B2: Text Field
Cell C2: Combo Drop Down Selection (Cancellation, MAG, PCR, COCC, LOM)
Cell D2: Combo Drop Down Selection (Yes, No)
Cell E2: Submit Button


I need a Macro to assign to the Submit button that will:
1. Will take the info entered into the form fields and paste them in the same order of cells A,B,C,D starting on row 4.
2. Will check if data has already been entered on a row and if so paste to the next row.
3. Will reset the form fields once the data has been submitted.
4. Save the worksheet without confirmation.

I have also created an example row on line 4 as of what the output would look like. Thanks in advance for all your help.

playaller_form_example.xlsm