Return multiline textbox data to separate rows

Here's a quick one I hope.

Users are allowed to cut and paste a series of values into a multiline textbox. What I need to have done is have each value placed into the first column of each new row and find the next vacant row in the first column on subsequent entries:

The Data Looks like this inside the TextBox:

ATT09405532
ATT09405533
ATT09405542
ATT09441141
ATT09442023
ATT09469065
ATT09429559
ATT09429591
ATT09429595
ATT09442234
ATT09457425
ATT09457430

With the below code on the userform, all the data transfers to one cell. How can I parse this?

Please Login or Register  to view this content.

Best!

pt

Thank you. Half right. It parses the data into separate rows, but it's repeating the first value in each row.

I cut and paste this into the Textbox (BTW I had to change this sub to respond off the Exit Event out of the TextBox rather than the Enter)

ATT09405532
ATT09405533
ATT09405542
ATT09441141
ATT09442023
ATT09469065
ATT09429559
ATT09429591
ATT09429595
ATT09442234
ATT09457425
ATT09457430

but the sub returns:

ATT09405532
ATT09405532
ATT09405532
ATT09405532
ATT09405532
ATT09405532
ATT09405532
ATT09405532
ATT09405532
ATT09405532
ATT09405532
ATT09405532
ATT09405532

It's not looking for the next available blank row for the next series of entries (but I believe I can figure that part out).