Forum Discussion
Dynamic cell validation with different types of validation
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.
That would require VBA, so it would work only in the desktop version of Excel for Windows/Mac, not in the online version, nor on Android/iOS. Users would have to allow macros.
Would that be OK?
- Yes if that's the only solution this would be great.