Excel VBA - Need to get a specific line from TextBox and send to an specific Cell

Question

So I have this TextBox where the user can inform different serial numbers

After Pressing the button it should look like this:

Here's 2 hours of progress:

The result I get:

Been trying to get the text from a specific line of the String But I have little to no vba knowledge and don't know if there's any way of doing this.

Answer 1

Moving your string into an array first is a good choice I hope this helps you.