Multiple combo boxes

I am currently producing a data sheet which used values
selected from 2 combo boxes to produce a given output.
The problem is that I would like to have the values of the
second combo box directly dependant on what value was
chosen from the first combo box.

For example cells A1 to A4 are for the first combo box and
by selecting from the first combo box 'A1' allows the
second combo box to display only the data from cells B1 to
B10, and again from the first combo box selecting 'A2' to
display only the data from cells C1 to C10.

Any ideas?

Lee

Hi

Have a look at Debra's site:
http://www.contextures.com/xlDataVal02.html

--
Andy.


"Lee" wrote in message
...
I am currently producing a data sheet which used values
selected from 2 combo boxes to produce a given output.
The problem is that I would like to have the values of the
second combo box directly dependant on what value was
chosen from the first combo box.

For example cells A1 to A4 are for the first combo box and
by selecting from the first combo box 'A1' allows the
second combo box to display only the data from cells B1 to
B10, and again from the first combo box selecting 'A2' to
display only the data from cells C1 to C10.

Any ideas?

Lee

I've recieved a good sample file from Bob Phillips.
You could request that he send you one as well (to get his
e-mail - I think his last post was about April 24/04 or
Page 30).

-----Original Message-----
I am currently producing a data sheet which used values
selected from 2 combo boxes to produce a given output.
The problem is that I would like to have the values of
the
second combo box directly dependant on what value was
chosen from the first combo box.

For example cells A1 to A4 are for the first combo box
and
by selecting from the first combo box 'A1' allows the
second combo box to display only the data from cells B1
to
B10, and again from the first combo box selecting 'A2' to
display only the data from cells C1 to C10.

Any ideas?

Lee
.