Forum Discussion
How to make a cell either inactive or select from dropdown list depending on a value in another cell
I have a cell where I want the input to be restricted depending on the value in another cell. In this case the restricted value has to be between selecting from a drop down list or make it inactive. See below described example:
Cell A1 is limited to a "Yes" or "No" value basis a drop down list.
In cell A2 would I then like the answer possibility to be depending on the value in A1. If the value in A1 is "No" then I want A2 to be inactive for any input. However if A1 is "Yes" I want A2 to pick values from a defined drop down list. That dropdown list is preferred to be via a table list created in a separate sheet.
Hope my above cryptical enquire make sense, otherwise please ask for clarification.
Thanks in advance if what I'm asking for is even possible.
See the attached workbook. It is a macro-enabled workbook, so you'll have to allow macros when you open it.
2 Replies
See the attached workbook. It is a macro-enabled workbook, so you'll have to allow macros when you open it.
Your description makes partial sense.
A bit confusing is this sentence: Cell A1 is limited to a "Yes" or "No" value basis a drop down list.
Is it Yes or No, and what's the relation to the drop down list? Or is the drop down list just those two possible answers?
Anyway, it is possible to have secondary answers in drop-down (data validation) lists that change based on a primary set of answers to their own drop-down (data validation) lists. I'm attaching a demo file I've created to show how that can work.
