Get List of options from data validation

[Amrinder_Singh]

Hi,
I have some values in my data validation from which user can choose value, is there any way i can get out those validations values from there and store to variable

[John.He]

@Amrinder_Singh,
Data validation is the ability to set rules pertaining to data entered on a worksheet. You can refer to the following document.

Data Validation

When data validations are implemented, then validation can be checked by assigning different values in the cells. Cell.GetValidationValue can be used to fetch the validation result.

Data Validation