Thread: List Boxes
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default List Boxes

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)

"Bob Phillips" wrote in message
...
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" wrote in message
...
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