Thread: List Boxes
View Single Post
  #2   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

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