• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. Y

    Add or remove a data validation list based on a cell value

    Hi Suresh, I have changed to a list box which provides for the cell link value. I have used to cell link value to swith on and off my decision tree. Although this is not the most complete solution, it is more elegant then trying to use data validation lists. Thanks Yunus
  2. Y

    Add or remove a data validation list based on a cell value

    Hi Suresh, In your last statement, therin lies the problem. What I am builing is a decision tree for use as a template. I do not want the user to have to physically delete (Yes or No)as these values keep the rest of the decision tree open. What I am aiming to get is that if the first cell...
  3. Y

    Add or remove a data validation list based on a cell value

    Hi Muneer, Thanks for the reply. This is exactly what I have done - what I want is that if A1 is blank no list should be returned. The way you and I have it, the last selected value Yes or No remains in the cell when A1 reverts to a balsnk cell. Thanks Yunus
  4. Y

    Add or remove a data validation list based on a cell value

    Hi, I have a cell, say a1 which has the value "Validate". In cell a2 I want to include a data validation list ("yes,no") which is have named as Decision. Is there a way to include a drop down list only when cell a1="validate" and no list when a1 is blank. I tried...
Back
Top