Hi all

Can someone help me with a problem of reading data from a sheet cell with multiline text to a listbox using VBA?

I have created a userform textbox which allows multiple selection of items from that listbox, which then inserts the selected data into a cell on a worksheet. This works ok. But when I want to transfer the text into another listbox using the following code, I get the text concantenated and prefixed with a 'P' backwards symbol.

Can anyone help solve this problem? 

ListBox2.RowSource = Range("U" & lRow, Cells(Rows.Count, 21).End(xlUp)).Resize(, 4).Address
    Me.ListBox2.ListIndex = ListBox2.ListCount - 1