Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Selecting subsets using combo boxes or list boxes | Excel Discussion (Misc queries) | |||
Questions on combo boxes and list boxes. | New Users to Excel | |||
List boxes/combo boxes | Excel Programming | |||
List Boxes (Help!) | Excel Programming | |||
List boxes | Excel Programming |