List Boxes

[RC]

I am creating a report with a listbox. The listbox contains doctors names
and when you click on a doctors names i want the label boxes and textboxes
on the page that give more inforamtion about the selected person to change.
Can anyone tell me how to do this or give me a good website about listboxes
and also comboboxes.
Thanks

 

[Bob Phillips]

Have a table with the doctors names in column 1, then the other details in
column 2, 3, etc.

Then when you click on the listbox, take the selected value, do a VLOOKUP
into the table to extract the other details, and load the labels and
textboxes with that data.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[RC]

Cound you give me an example of the code on how to do the vlookup?

 

[Rich Cooper]

Could you give me an example of what that code would look like bob? I
am not very good with listboxs, nor lookup, first time using either in
an excel application

 

[Bob Phillips]

Okay, set-up a table in H1:K10 say like so

Dr Jones GP Merseyside Part-Time
Dr Peters GP Manchester Full-Time
Mr Walters Consultant Bootle Full-Time

Load the list box with the names (you can set the Rowsource property to
H1:H10). Then on the userform the listbox click event would lock something
like

Private Sub ListBox1_Click()
With Me.ListBox1
Label1.Caption = WorksheetFunction.VLookup(.Value, Range("H1:K10"),
2, False)
TextBox1.Text = WorksheetFunction.VLookup(.Value, Range("H1:K10"),
3, False)
End With
End Sub

This gets the 2nd column (e.g. GP) to the label, and the 3rd (area) to the
textbox.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)