Hi,
I’m trying to use data validation to do the following action but with no success. I do not know if it is even possible:
If cell A1=False then cell A2 to get the value “N/A”, otherwise, If cell A1=True then cell A2 to be assigned a drop down list of 2 elements (“A”, “B”).
Can someone please help me how to do it?
Thanks in advance,
Tas
What you want to do is called "cascading dropdowns" and there are several ways to do it. I suggest that you do a web search on them. The solution presented here is specific to this requirement and while it does work, it isn't very general and might not work for future requirements.
With this particular requirement, you also have a unique solution.
First make a couple of named ranges.
- List1 contains only the cell E1 which contains the value N/A
- List2 contains the cells F1:F2 which contain the values A and B.
The validation in cell A2 is =IF($A$1=TRUE,List1,List2)
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
Hi,
Thank you for your reply.
I have actually got this far. However if you notice my problem is not about using 2 list but 1 value and 1 list. So, when the cell A1=True then cell A2=”N/A” (assignement).
When A1=False then I need the drop down list with 2 elements (A, B).
Thanks again for your help, I’m looking forward for your expert help!
Tassos
Add this code to the worksheet module for Sheet1 (or whatever sheet you want this to happen on).
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks