String and Combox Question

[jason_kelly]

Hello,

I have a string that is seperated by a pilcrow ¶. Currently, when I add my string into my Combo box, it comes out in one line ex:

[COMBO BOX]
value1¶value2¶value3¶value4¶value5

How can I add my string (above) into seperate lines in a combo box? ex:

[COMBO BOX]
value1
value2
value3
value4
value5

Any help with this is greatly appreciated.

Cheers,

Jay

[Kenneth Hobs]

[VBA]ComboBox1.List = Split(Replace("value1¶value2¶value3¶value4¶value5", "¶", vbLf), vbLf)[/VBA]