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.

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.
>
>
>.
>