Thread: drop down list
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
choice[_2_] choice[_2_] is offline
external usenet poster
 
Posts: 84
Default drop down list

i have 3 drop down list. Make/Model/Part
for make i am using (Motorola,Nokia,Samsung,LG,etc)
there are about 3 times as many models for nokias then any other make. but
so i have the range to cover the maximum possibilities. but when i click on
somehting other then nokia, there are a lot of blank possibilities

Is there a way to change the range of the second drop down list based on the
value of the first?