wokring with mulitple combo boxes. Need Help.

[techxupport - ExcelForums.com]

Today at work I was given a project to do and I sit my by desk an
google for 3 hours and can't found a clue on how to set this up. An
help will be deeply appreciated

The easiest way for me to explain this is using automaker as a
example

Let say there are 3 auto makers
Hond
Nissa
Toyot

Each of them have different model car
Honda: Accord, Civic, Pilo
Nissan: Maxima, Altima, Pathfinde
Toyota: Camry, Corolla, Landcruise

What I want to do is when I select Honda from the first combo box, o
the second combo box will only shows Accord, Civic and Pilot and s
on for the Nissan and Toyota

I've Honda on A1, Nissan on A2 and Toyota on A
Accord on B
Civic on B
Pilot on B
Maxima on B
Altima on B
Pathfinder on B
Camry on B
Corolla on B
Landcruiser on B9

Which Combo box should I use, Form or Control Toolbox Combo box?

Please help

 

[Dave Peterson]

Maybe data|validation???

Debra Dalgleish shows how to use dependent lists at:
http://www.contextures.com/xlDataVal02.html

 

[SeaparkJohn]

Hi,

seperate each automaker out into a column and place at the top of the
column. i.e. toyota goes in K1,Camry in K2,Corolla in k3 and on and on.
According to the list you placed below, you would now have three columns side
by side. Name each column by highlighting the column and go to
Insert>Name>Define.

Use the forms menu to add a group box to your spreadsheet. Now add an
option button foe each automaker to the group box. Right click on each
button and select "Assign Macro". In the macro code write the following:

Columns("E:E").Value = Range("nissan").Value

Where colum e is where you want to place the results of the search.
"Nissan" is the column of values you want to select.

Repeat the macro for each button in the group box by double clicking. Leave
the column as E or what ever column to add to, and change the range to equal
the selection.

Hope this helps...