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.


.