Visual Basic List Box Help!

[Ganty]

Hi Chaps

A quick (well, I hope!) n00b query with Visual Basic within Excel.

I'm creating a contact information project, but am having trouble with list boxes.

I have a list box with a name of organisation, but I want, upon clicking on said organisation, their contact information to appear in a label/pop up box etc...

The list box's row source is set to a range with the relevant companies information, but I am unsure of how to display that companies correct information when selecting it.

For example, if I click on "Tom's Taxi's" I would like a pop up or a label to display that contacts address, phone number etc...

Any help greatly appreciated.

Gantybop

[fevernova]

a simple display what is selected in the list box would be

Private Sub Command1_Click()
Label1.Caption = List1.Text
End Sub

i did this in vb6 but due to the fact u made a relation to databases i am guessing ur doing vb.net the code should change so much as for the link to ur data i have no idea