| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 3 ?s. Drop downs and comments | Excel Discussion (Misc queries) | |||
| How to increase font size in drop downs within workbook | Excel Worksheet Functions | |||
| drop downs | Excel Discussion (Misc queries) | |||
| How do I create a form with drop downs that narrows choices? | Excel Discussion (Misc queries) | |||
| Drop Downs Menus | Excel Worksheet Functions | |||
Linear Mode
