Forum Discussion
Solved
Dynamic cell validation with different types of validation
Hello, I would like to have different types of data validations in 1 cell but I haven't found a way to do this. I'm also not sure it is possible in Excel. This is what I need: If cell value of ...
Thank you so much for this. From this I've managed to exactly adapt the coding to what I needed.
If A1 is A, should the user be able to enter any number, or just numbers from a limited set, for example 1, 2, ..., 10?
https://xalgmbh-my.sharepoint.com/:x:/g/personal/bart_vanwynsberghe_weverducre_com/EeoY3h0UcuJLncL2BTs-sycBYrykUuD9GNLjUaXj8uOprA?e=J0uzaz
All numbers should be allowed when A1 is N, no list. IF A1 is A then a number of entries should be possible from a drop down list (in my case these are even texts). I have an example file made but (don't know whether I added it here correctly). In the file I managed to have multiple drop downs depending on a cell value.