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
|