Put into next empty cell

[emily2309]

If i am putting information from a form onto a sheet, how do i make it go into the next empty row?

 

[njimack]

Something like this:
Sheets(Sheet1").Range("A" & Rows.Count).End(xlUp).Offset(1,0) = txtbox1.Value