Conditional drop-downs

B

Brad

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

Brad

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

Debra Dalgleish

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

Brad

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

Brad

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

Thanks again.
 
Top