Conditional drop-downs
 

I have the logic down for the condtional drop-down with one exception -
making the validation of data work correctly for the second list.

What I'm doing is coming up with a list of products that can be shown in
different states. If product 1 is okay in Texas and I select product 1 and
texas everything is cool. However if I select product 2 and it is not okay
in texas - I'm not getting an error message that texas is invalid - but the
conditional drop down for the second product does not show texas as a valid
choice.

What am I missing.

Conditional drop-downs
 

see perhaps:

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


--
Gary''s Student
gsnu200702


"Brad" wrote:

I have the logic down for the condtional drop-down with one exception -
making the validation of data work correctly for the second list.

What I'm doing is coming up with a list of products that can be shown in
different states. If product 1 is okay in Texas and I select product 1 and
texas everything is cool. However if I select product 2 and it is not okay
in texas - I'm not getting an error message that texas is invalid - but the
conditional drop down for the second product does not show texas as a valid
choice.

What am I missing.

Conditional drop-downs
 

I essentially used this logic - using the offset - rather than the indirect
function and it is not validating the second list - once it has data already
in it.

"Gary''s Student" wrote:

see perhaps:

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


--
Gary''s Student
gsnu200702


"Brad" wrote:

I have the logic down for the condtional drop-down with one exception -
making the validation of data work correctly for the second list.

What I'm doing is coming up with a list of products that can be shown in
different states. If product 1 is okay in Texas and I select product 1 and
texas everything is cool. However if I select product 2 and it is not okay
in texas - I'm not getting an error message that texas is invalid - but the
conditional drop down for the second product does not show texas as a valid
choice.

What am I missing.

Conditional drop-downs
 

If there's a blank cell in the list of states for product 2, you'll be
able to type any entry in that cell. If that's the problem, remove the
blank cell from the range, and you should see an error message for
invalid entries.

Brad wrote:
I have the logic down for the condtional drop-down with one exception -
making the validation of data work correctly for the second list.

What I'm doing is coming up with a list of products that can be shown in
different states. If product 1 is okay in Texas and I select product 1 and
texas everything is cool. However if I select product 2 and it is not okay
in texas - I'm not getting an error message that texas is invalid - but the
conditional drop down for the second product does not show texas as a valid
choice.

What am I missing.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Conditional drop-downs
 

It's not a blank cell -

In the example that I used - if I type in Texas - for the second product it
states that it is invalid. However, since Texas was in the cell before I
changed the product code - it doesn't do the validation.

Does this help describe the problem.

"Debra Dalgleish" wrote:

If there's a blank cell in the list of states for product 2, you'll be
able to type any entry in that cell. If that's the problem, remove the
blank cell from the range, and you should see an error message for
invalid entries.

Brad wrote:
I have the logic down for the condtional drop-down with one exception -
making the validation of data work correctly for the second list.

What I'm doing is coming up with a list of products that can be shown in
different states. If product 1 is okay in Texas and I select product 1 and
texas everything is cool. However if I select product 2 and it is not okay
in texas - I'm not getting an error message that texas is invalid - but the
conditional drop down for the second product does not show texas as a valid
choice.

What am I missing.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Conditional drop-downs
 

There are a couple of sample files here with cross dependent validation:

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

Look for 'DV0037 - Dependent Lists Country City' or 'DV0013 - Cross
Dependent Validation Lists'

Maybe you can adapt one of those solutions to your dropdown lists.


Brad wrote:
It's not a blank cell -

In the example that I used - if I type in Texas - for the second product it
states that it is invalid. However, since Texas was in the cell before I
changed the product code - it doesn't do the validation.

Does this help describe the problem.

"Debra Dalgleish" wrote:


If there's a blank cell in the list of states for product 2, you'll be
able to type any entry in that cell. If that's the problem, remove the
blank cell from the range, and you should see an error message for
invalid entries.

Brad wrote:

I have the logic down for the condtional drop-down with one exception -
making the validation of data work correctly for the second list.

What I'm doing is coming up with a list of products that can be shown in
different states. If product 1 is okay in Texas and I select product 1 and
texas everything is cool. However if I select product 2 and it is not okay
in texas - I'm not getting an error message that texas is invalid - but the
conditional drop down for the second product does not show texas as a valid
choice.

What am I missing.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Conditional drop-downs
 

Thanks DD. I wasn't able to get back to this until today - but that did the
trick.

Thanks again.

"Debra Dalgleish" wrote:

There are a couple of sample files here with cross dependent validation:

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

Look for 'DV0037 - Dependent Lists Country City' or 'DV0013 - Cross
Dependent Validation Lists'

Maybe you can adapt one of those solutions to your dropdown lists.


Brad wrote:
It's not a blank cell -

In the example that I used - if I type in Texas - for the second product it
states that it is invalid. However, since Texas was in the cell before I
changed the product code - it doesn't do the validation.

Does this help describe the problem.

"Debra Dalgleish" wrote:


If there's a blank cell in the list of states for product 2, you'll be
able to type any entry in that cell. If that's the problem, remove the
blank cell from the range, and you should see an error message for
invalid entries.

Brad wrote:

I have the logic down for the condtional drop-down with one exception -
making the validation of data work correctly for the second list.

What I'm doing is coming up with a list of products that can be shown in
different states. If product 1 is okay in Texas and I select product 1 and
texas everything is cool. However if I select product 2 and it is not okay
in texas - I'm not getting an error message that texas is invalid - but the
conditional drop down for the second product does not show texas as a valid
choice.

What am I missing.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Conditional drop-downs
 

You're welcome! Thanks for letting me know that it worked.

Brad wrote:
Thanks DD. I wasn't able to get back to this until today - but that did the
trick.

Thanks again.

"Debra Dalgleish" wrote:


There are a couple of sample files here with cross dependent validation:

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

Look for 'DV0037 - Dependent Lists Country City' or 'DV0013 - Cross
Dependent Validation Lists'

Maybe you can adapt one of those solutions to your dropdown lists.


Brad wrote:

It's not a blank cell -

In the example that I used - if I type in Texas - for the second product it
states that it is invalid. However, since Texas was in the cell before I
changed the product code - it doesn't do the validation.

Does this help describe the problem.

"Debra Dalgleish" wrote:



If there's a blank cell in the list of states for product 2, you'll be
able to type any entry in that cell. If that's the problem, remove the
blank cell from the range, and you should see an error message for
invalid entries.

Brad wrote:


I have the logic down for the condtional drop-down with one exception -
making the validation of data work correctly for the second list.

What I'm doing is coming up with a list of products that can be shown in
different states. If product 1 is okay in Texas and I select product 1 and
texas everything is cool. However if I select product 2 and it is not okay
in texas - I'm not getting an error message that texas is invalid - but the
conditional drop down for the second product does not show texas as a valid
choice.

What am I missing.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html




--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html