DropDownBoxes Which update base on other dropdown values
 

I want to be able to build a bunch of drop down boxes
which all feed off the same named range. But I want to
limit the values in each successive box based on what has
already been chosen in the other boxes. Say I have a 10
cells A1:A10 with dropdown boxes B1:B10. I want the
first box (B1)to provide a list of options from 1-10
(assume named range). Say 4 is chosen. In the next box,
I only want the dropdown list to include 1-3,5-10. If
the next list is assigned 9, then the third box should
only provide a list of 1-3,5-8,10 etc. So I effectively
have set up values from 1-10 for all ten cells

In a perfect world the user would only be forced to start
in box 1 and then could proceed down the list in any
order they desire. I would then have a macro in the
worksheet that checks to see that the values all
increment properly from 1-10. So it will check that
there has been a 1 selected in one box and that all other
boxes with values increment


Does anyone know how to do this.

Thanks.

DropDownBoxes Which update base on other dropdown values
 

Peo Sjoblom developed a technique to do just what you're
asking. You can find it on Debra Dalgleish's website:

http://www.contextures.com/xlDataVal03.html

HTH
Jason
Atlanta, GA

-----Original Message-----
I want to be able to build a bunch of drop down boxes
which all feed off the same named range. But I want to
limit the values in each successive box based on what
has
already been chosen in the other boxes. Say I have a 10
cells A1:A10 with dropdown boxes B1:B10. I want the
first box (B1)to provide a list of options from 1-10
(assume named range). Say 4 is chosen. In the next
box,
I only want the dropdown list to include 1-3,5-10. If
the next list is assigned 9, then the third box should
only provide a list of 1-3,5-8,10 etc. So I effectively
have set up values from 1-10 for all ten cells

In a perfect world the user would only be forced to
start
in box 1 and then could proceed down the list in any
order they desire. I would then have a macro in the
worksheet that checks to see that the values all
increment properly from 1-10. So it will check that
there has been a 1 selected in one box and that all
other
boxes with values increment


Does anyone know how to do this.

Thanks.


.