Userform - always add data to next available empty row

Hi all,

I have attached an example of my Userform and how I would like my data to be inputted onto the next available empty row on sheet 'DB' for the range A3-L3 (excluding D3 though).

So the first user's data will be inputted: A3-L3 (excluding D3), 2nd user A4-L4 (excluding D4), 3rd user A5-L5 (excluding D5)and so on... (see example worksheet)

After the Command Button is pressed the form should reset itself ready for the next user (but stay open).

I have set up the form and the Row Source for each combo-box (using named ranges).

Basically I'm looking for some code which I can attach to the Command Button which will execute the above.

Can anyone help?

(also i would like the form to open on Sheet1 whenever the workbook is opened if thats easy to do...?)

hi Plumby
glad it helped you!