View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Emma Emma is offline
external usenet poster
 
Posts: 55
Default Displaying a result based on user selection

I need to display a result based on what a user selects from a list of options.

Example:

Selection A - Make of car
Mazda
Ford
GMC
Porshe
Toyota

Selection B - Number of Doors
2
4
5

Result possibilities:
If the user selects Ford and 2 door then the result would come up with an
F-150.
If the user selects Mazda and 5 door then the result would come up with a
Mazda 3.
etc.

How do I do this. I can create drop down lists and list boxes, or control
boxes to show the Selection A & B however I don't know how to get it to
display the results based on the selection.

Thanks for your help!