Vb code needed for row

[bamaisgreat]

ok, I have made a form that has a few textboxes and a combobox, i have a spreedsheet were the data will be going to. All the information entered is going to one row. I need some code that will let the next entry go to the next empty row, and so on.

 

[VoG]

Try like this

Range("A" & Rows.Count).End(xlUp).Offset(1).Value = TextBox1.Value

 

[bamaisgreat]

Thanks, Will this still work if there is a formula in one of the cells across there.

 

[VoG]

Should do.

 

[bamaisgreat]

Thanks a Million