Copy multiple line Textbox data to range

[L plates]

Hi All,

I have a userform where I would like users to be able to paste multiple lines into a textbox with one paste (a client address from word or a PDF) then transfer the data onto a sheet with a command button. I have simplified and attached what I have so far to show what I am trying to achieve.

I have pre-populated the textbox with exactly the kind of data the textbox is likely to have pasted into it. When the Add Address button is pressed my code adds all the data into single cell. What I need is for the data to be distributed down the column to separate each line of the address. When the address is copied from its original source and pasted into the sheet it exhibits the behaviour I am after. I have shown an example of this in the file.

How do I get the form to behave to this requirement?

Many thanks in advance,

[p24leclerc]

try this modified macro for your Add Data button:

Please Login or Register  to view this content.

It splits the address using the CR-LF characters at the end of each line. The only issue I can see is if you have more lines then you expect.

[L plates]

Hi Pierre,

Thank you for your solution, it works perfectly! Luckily in the actual application there are 7 lines that will never be exceeded.

Thanks again!