Private Sub Listbox1_Click()
textbox1.Text = Listbox1.List(Listbox1.ListIndex,0)
textbox2.Text = Listbox1.List(Listbox1.ListIndex,1)
' etc

End Sub

--
Regards,
Tom Ogilvy


"peter_rivera"
wrote in message
news:peter_rivera.1qzhqq_1119369976.8997@excelforu m-nospam.com...

Good morning all,

On a userform, I want to link a listbox to several other textboxes on
the form so that when the listbox changes all of the other values in
the textboxes will change.

Listbox - Name - Textboxes = address, phone, etc...

How can I do this in Excel? Thanks!


--
peter_rivera
------------------------------------------------------------------------
peter_rivera's Profile:
http://www.excelforum.com/member.php...o&userid=24495
View this thread: http://www.excelforum.com/showthread...hreadid=380885