If Then with Validation

I have setup a cell so that it validates against a list on a different
worksheet in the workbook. But based upon which item is selected from the
list I want the next cell to be a different validation list -- e.g. If I
select B from the validation list I want the next cell to give me a list of
options 8 - 15, but if I select C from the first validation list I want the
next cell to give me a list of options 16 - 25. I can't find any function
that will do this? Is there anyway to accomplish this? It is almost like a
If a specific Item is selected from the first validation list, Then that will
determine the Validation list for the next cell.

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


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"PapaBear" wrote in message
...
I have setup a cell so that it validates against a list on a different
worksheet in the workbook. But based upon which item is selected from the
list I want the next cell to be a different validation list -- e.g. If I
select B from the validation list I want the next cell to give me a list
of
options 8 - 15, but if I select C from the first validation list I want
the
next cell to give me a list of options 16 - 25. I can't find any function
that will do this? Is there anyway to accomplish this? It is almost like
a
If a specific Item is selected from the first validation list, Then that
will
determine the Validation list for the next cell.

Dependent DV list instructions from Debra's site.

http://www.contextures.on.ca/xlDataVal02.html


Gord Dibben MS Excel MVP

On Mon, 18 Feb 2008 15:52:01 -0800, PapaBear
wrote:

I have setup a cell so that it validates against a list on a different
worksheet in the workbook. But based upon which item is selected from the
list I want the next cell to be a different validation list -- e.g. If I
select B from the validation list I want the next cell to give me a list of
options 8 - 15, but if I select C from the first validation list I want the
next cell to give me a list of options 16 - 25. I can't find any function
that will do this? Is there anyway to accomplish this? It is almost like a
If a specific Item is selected from the first validation list, Then that will
determine the Validation list for the next cell.