Split String at every "/" then put split string results into a multiline textbox.

Hi everyone, i know this is probably simple but i need to split a string.

such as

"text1/text2/text3/text4/text5"

and the results to be put into a textbox with each result on a new line.

iv tried:

txtManualSpecs.Text = VBA.Split(frmDISPLAY.Listbox062HARNBK.Column(2), "/", -1, vbTextCompare)

my string comes from a listbox column. as you can see in the example.

but that throws and error 13.



cheers