multiple combo boxes

[jeff]

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"

 

[Roger Govier]

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

 

[jeff]

Hi Roger,

Thanks for that, will look at that and dee what i can do