MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Display Values of one Listbox based on Another Listbox


Posted by JohnH on July 14, 2001 7:24 AM

I have two cells in my template that I use the Data Validation method for data capture from the users.
In one cell the validation list consists of a list of Contractors.
The second list box is for names of Technicians. What I would like to do is only show the names of Technicians that are associated with the Contractor selected from the first listbox. Is this possible? If so how do I go about getting it done?

Thanks.

John


Posted by Aladin Akyurek on July 14, 2001 7:34 AM

Yes, it's possible. Care to post your Contractors X Technicians table?

Aladin

Posted by JohnH on July 14, 2001 8:34 AM

Here is an example:
Technicians
Contractor CAGA CARD CIER DBLG
CAGA John H Brent A CIER1 DBLG 1
CARD Mike M Robin P CIER2 DBLG 2
CIER David A Linda M CIER3 DBLG 3
DBLG Chris T Carol P CIER4 DBLG 4

Right now I have a list box to Select contractors
and I would like the list box for the technicians to
only show the technicians associated with the contractor and
not a complete list of the technicians. The above
sample is small but in reality some contractors have
more than 100 technicians working for them so a list of all
technicians would be much too long.

Thanks.

John

Posted by Aladin Akyurek on July 14, 2001 9:32 AM

John -- CAGA is a contractor and John H plus Brent A the technicians associated with CAGA, right? But what are CIER1 DBLG1? Why are contractors are listed in columnwise and again rowwise?

Aladin

Posted by JohnH on July 14, 2001 10:28 AM

Perhaps this will make it easier:

Please note ----- are just fillers
Contractors are on the first row and the technicians for those contractors are right below.

Contractors are: CAGA-----CARD-----CIER-----DBLG
Technicians are: CAGA1----CARD1----JohnH----Mike S
-----------------CAGA2----CARD2----LynnA----Robin A
-----------------CAGA3----CARD3----JoeM-----David S
-----------------JohnH----CARD4----Nancy----Ron Wyman

Hope this is a little more useful.

Thanks.

John


Posted by Aladin Akyurek on July 14, 2001 10:47 AM

:: Contractors are on the first row and the technicians for those contractors are right below. Contractors are: CAGA-----CARD-----CIER-----DBLG

John -- Am I to conclude that when CAGA is selected from your first list box, the technicians right below CAGA only should populate your second list box? If so, this is going to be much easier.

Aladin