Next blank Row

Hi
I have a worksheet that has 2 userforms. I have a VBA code that allows the selected records to show in a specific cells, but when I select another one it goes over the top of the first one, i need it to appear and the next blank row. Can anyone tell me what I am doing wrong.

Please Login or Register  to view this content.

what do you mean by this?

Originally Posted by Evie76

but when I select another one it goes over the top of the first one

obviously you are doing something with a listbox and checking to see whether line items are selected.

to look for an empty row on the bottom of a list i use this

Cells(Rows.Count, X).End(xlUp).Offset(1, 0).EntireRow.Select

x is the column you want to check for empty cells

don't know if this helps