View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
rl4lsu rl4lsu is offline
external usenet poster
 
Posts: 2
Default Form Control Drop Down Lists

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 Ive 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.