Forum Discussion
Marco2220
Dec 10, 2021Copper Contributor
Conditional Validation, with list option or any data option
Hi guys. I want to use the conditional validation but in some cases the user can input any value. Somebody can help me? Example: My operation is in Brazil. Is there a column with the State of the cu...
Juliano-Petrukio
Dec 10, 2021Bronze Contributor
Data validation only works with existing data.
To add new itens to your list of values you either can add it by accessing the list (01) or using vba to add the new item (02).
To be honest, I would recommend populate your list with all possible and useful values and avoid the option 02.
The reason of data validation is to standardise your data, so imagine the final user can add his own value, a lot of mistakes will occur.
To add new itens to your list of values you either can add it by accessing the list (01) or using vba to add the new item (02).
To be honest, I would recommend populate your list with all possible and useful values and avoid the option 02.
The reason of data validation is to standardise your data, so imagine the final user can add his own value, a lot of mistakes will occur.