View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
r wilcox r wilcox is offline
external usenet poster
 
Posts: 14
Default Data Validation or Pull Down Menu

I'm trying to construct an input form that limits selections that a user can
pick. Data validation works for small lists, but for larger lists, I would
like to use multiple selections that narrow the choices depending on the
prior selection. For instance if someone chooses a certain model refrigerator
there next choice would limit the color selection to only the colors
available for that model. Can this only be accomplished with a program and if
so how could it be set up?

Thanks.