multiple combo boxes
 

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"

multiple combo boxes
 

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"

multiple combo boxes
 

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"