Forum Discussion
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 A1 is N, the data validation in A2 should allow only numbers to be entered
If cell value of A1 is A, the data validation of A2 should show a drop down list
If cell value in A1 is empty then no validation should be done on cell A2
Thank you so much for this. From this I've managed to exactly adapt the coding to what I needed.
7 Replies
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?
