Next Empty Row

[seasmith]

I have used code like this

Range("A65536").End(xlUp)(2, 1) = txtrelief.Text

before to find the next empty row and have a text box from a form print to that row. This time though I am having some problems. Whatever I type in the text box on the form lets say I type in JimJones it enters the informating
J
Ji
Jim
JimJ
JimJo and so on
can anyone help me with this? Or is there any other code I could use to find the next empty row and have a text box from a form print in it?

 

[Norie]

Weird, the only time I couldn't get what you describe was when the next row was based on a different column than the one the text was gong to.

 

[seasmith]

Also I only had to change the code for the first text box on the form none of the rest.

this is the code i used

Range("A" & Rows.Count).End(xlUp).Offset(1).Value = txtrelief.Text
Range("A65536").End(xlUp)(1, 2) = txtlocation.Text

all of the code is the same as I had it except for the first one