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.
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.
See the attached demo.
Select Formulas > Name Manager to see the defined names I used.
Right-click the sheet tab of Sheet1 and select 'View Code' to see the VBA code.
Thank you so much for this. From this I've managed to exactly adapt the coding to what I needed.
I'll work on it.