Text in a Cell to ListBox

[m-a-c-f]

Hi.

I have some cells in my work that have more then on line, like whem you type Alt+Enter, for example:

Cell A1 = abababab
bcbcbccbc
fgfgfgfgfgfg

I need to extract each line and put in a ListBox, how can I do that?

Regards,

Manoel

[Richard Buttrey]

Hi,

Unfortunately I've not got access to Excel just at the moment but there are two approaches you could take. Either use some helper columns to search the string for the 1st, 2nd, 3rd etc. occurrences of the code 10 (enter character) and then use string slicing functions to create those helper column values and load to your list boxes, or use some similar string slicing technique with a VBA macro.

[mike7952]

You dont say where you Listbox is, Im assuming its on a userform or its a Active X Control Listbox

Please Login or Register  to view this content.