Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
I want to select a car maker from a combo box and use that value to show a range of their models in a second combo box, box 1 Car maker "ford", "Vauxhall" etc box 2 car models "explorer", "escort", "focus", "astra","omega" |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi Jeff
Take a look at http://www.contextures.com/xlDataVal02.html This will show you how to use dependent lists. Debra also shows how to use Combo boxes as opposed to Data Validation at http://www.contextures.com/xlDataVal10.html -- Regards Roger Govier "jeff" wrote in message ... Hi, I want to select a car maker from a combo box and use that value to show a range of their models in a second combo box, box 1 Car maker "ford", "Vauxhall" etc box 2 car models "explorer", "escort", "focus", "astra","omega" |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() Hi Roger, Thanks for that, will look at that and dee what i can do "Roger Govier" wrote: Hi Jeff Take a look at http://www.contextures.com/xlDataVal02.html This will show you how to use dependent lists. Debra also shows how to use Combo boxes as opposed to Data Validation at http://www.contextures.com/xlDataVal10.html -- Regards Roger Govier "jeff" wrote in message ... Hi, I want to select a car maker from a combo box and use that value to show a range of their models in a second combo box, box 1 Car maker "ford", "Vauxhall" etc box 2 car models "explorer", "escort", "focus", "astra","omega" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Multiple combo boxes with unique duplicates showing only | New Users to Excel | |||
Selecting subsets using combo boxes or list boxes | Excel Discussion (Misc queries) | |||
Questions on combo boxes and list boxes. | New Users to Excel | |||
multiple combo boxes | Excel Discussion (Misc queries) | |||
Finding a record using multiple combo boxes as my search criteria | Excel Discussion (Misc queries) |