Hi Dominic
Been busy myself -- out all morning.

Just the job and spot on -- thanks for all your help

much appreciated

Mully

"dominicb" wrote:


Hi Mully

Apologies for the delay in my reply.

It depends on exactly how you've set up your list box, but I've just
tested this piece of code and it seemed to be working OK - is this what
you wanted?

Private Sub ListBox1_Click()
TextBox1.Value = ListBox1.List(, 0)
TextBox2.Value = ListBox1.List(, 1)
TextBox3.Value = ListBox1.List(, 2)
TextBox4.Value = ListBox1.List(, 3)
End Sub

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=393594