Hi

On a userform I have a list box that consists of 4 columns e.g.

121 - Joe Bloggs - 493 -1647

I would like to do the following on the same userform after highligting the
line
121 - Joe Bloggs - 493 - 1647 - in the list box.

TextBox1 = 121
TextBox2 = Joe Bloggs
TextBox3 = 493
TextBox4 =1647

all I end up with when trying to do it is that all the TextBoxes have 121
in them

Any help to solve this problem is much appreciated

Mully