Form Control Drop Down Lists

[rl4lsu]

Is there a way to have sequential drop down list boxes where the 1st list box
limits the available selections of the 2nd, 2nd to 3rd, (see example data
below). The goal is to identify a specific fruit with the 2nd box listing
only the types of fruits selected and the 3rd listing only the companies that
produce that fruit (e.g. Sunkist produces a Naval orange not a Granny Smith
orange). My thoughts and research tell me I can do this using “Form
Controls†in Excel – btw that is how the data is stored. But the reference
materials I’ve seen does not seem to address this scenario. Any help will be
appreciated.

Example:
1st Box List “Fruits†– Orange, Apple, Bananas.
2nd Box List “Descriptions†– Naval, Satsuma, Blood, Granny Smith, Red
Delicious.
3rd Box List “Companies†– Dole, Sunkist, Harry & David, Chiquita.

 

[ryguy7272]

I think these links will give you what you want (or darn close):
http://www.contextures.com/xlDataVal02.html
http://www.contextures.com/xlDataVal13.html


Regards,
Ryan--

 

[JLGWhiz]

The short answer is: Yes

First you have to have all of the categories listed somewhere on a sheet so
the code for each list box can be structured to go to the sheet and retrieve
that particular category. For example, all of you apple types would be
listed as a group in a range of a column or row. The same with oranges,
bananas, etc. Then, you could make listbox one the container for the fruit
variety. If apples is selected go to the range for the types of apples and
load listbox 2. Select Granny Smith and the code would then go to the range
for distributors and find the distributor for Granny Smith. You can see that
it would be necessary to cross index fruit to variety and variety to
distributor on the worksheet so that they can be easily found.

 

[rl4lsu]

Thanks, I will be able to use componets from both links to get the results I
need.

Kind Regards,
Rudy