VBA Code:
Dim Lastrow As Long, ws As Worksheet
Set ws = Sheets("Emails")
Lastrow = ws.Range("A" & Rows.count).End(xlUp).Row + 1 'Finds the last blank row
ws.Range("A" & Lastrow).Value = TextBox7.Text
ws.Range("B" & Lastrow).Value = TextBox8.Text
ws.Range("C" & Lastrow).Value = TextBox9.Text
This works great on a blank sheet, but i am trying to create another code that does the same thing, but it starts the first row at A10 filling A10 B10 C10 with the items typed and then the next items typed go to A11 B11 C11 but here is the kicker i want it to stop doing anything after A13 B13 C13 are filled. At somepoint I would clear (all those boxes as a group and want it to restart back at A10 B10 C10 (but i don't need nor want that particular code in this, the clearing is handled by another code all together) i just want it to stop filling rows after A13 B13 C13 are filled, and then just wait until A10 B10 C10-A13 B13 C13 are clear.
This is going to run after a certain box is exited.
Ideas?