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.
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.