As far as I can tell, You will need to create a text_box Enter privat
sub

I just put 1 small column of data in but the theory should hold tru
for your example. For each field you want to be pre populated you coul
reference the colomn in the last data you entered. I referenced A1 a
the only cell to look at, but in your case you're constantly enterin
in data into multiple columns so you'll have to code in something lik
this for each column of data, and subsequently each text box:

Private Sub TextBox1_Enter()
'locate the column of data you want to reference the last cell in
Range("A1").select
'Find the last cell (assuming no blank cells)
Selection.End(xlDown).Select
TextBox1.Value = Selection.Value
End Sub

Keep in mind you'll also need the requisite TextBox_1Change() to ente
your data into the next cell.

Hope this helps

--
TylerDurde
-----------------------------------------------------------------------
TylerDurden's Profile: http://www.excelforum.com/member.php...fo&userid=1763
View this thread: http://www.excelforum.com/showthread.php?threadid=39021