Userform transfer data into worksheet

Hi, I'm not sure how to explain this in writing.

What I have is a file for new customer entry, with order quantity entry.

Textbox1.text would go to the next blank cell in column A, resize 5rows
Textbox3.text would be entered on the next blank cell on column C
Then textbox4.text on Column C still
textbox5.text
and so on.

I was hoping to use something similar the below code. i've tried but it kept replacing just one row.

For i = 2 to 5
With sheets1
.cells(lastrow,"C").value = me.controls("Textbox"&i).text
end with
Next i

Thank you

Thank you so much! Works perfectly!!!