Cascading Combo Boxes

[chimp]

I am sure that this topic has arisen befor, and i have carried out
search, without really finding what i am after.


I have a form on my spreadsheet that adds data, i am trying to link t
Comboboxes together,

My combo boxes are setup as follows.

CBOMANUFAC
Ford
Vauxhall
Toyota

CBOEDITIO
Ka
Fiesta
Galaxy
Vectra
Corsa

so that if i select:

Manufacturer - Ford

in the combo box cboEdition i only get those cars associated with Ford
ie, KA....Fiesta..Galaxy


please help


And

 

[RagDyer]

Try Debra Dalgleish's web page:

http://www.contextures.com/xlDataVal02.html
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


I am sure that this topic has arisen befor, and i have carried out a
search, without really finding what i am after.


I have a form on my spreadsheet that adds data, i am trying to link to
Comboboxes together,

My combo boxes are setup as follows.

CBOMANUFACT
Ford
Vauxhall
Toyota

CBOEDITION
Ka
Fiesta
Galaxy
Vectra
Corsa

so that if i select:

Manufacturer - Ford

in the combo box cboEdition i only get those cars associated with Ford,
ie, KA....Fiesta..Galaxy


please help


Andy

 

[chimp]

thanks for your help, however i am trying to do this via a form and no
directly on the spreadsheet itself.

I have attached my spreadsheet, so you can see more clearly what i a
trying to achieve.

On the spreadsheet there are three worksheets, on the worksheet title
"Sales there is a button called New Sale

when clicked it launches a form to open and this is where i want th
cascading options to happen.

Hope this makes sense.

And

+----------------------------------------------------------------
| Attachment filename: test.zip
|Download attachment: http://www.excelforum.com/attachment.php?postid=357800
+----------------------------------------------------------------