How to set data validation for numbers?

1 min read

Use the following code snippets to set data validation for numbers.

// Data Validation for NumbersIDataValidation validation1 = sheet.Range["A3"].DataValidation;

sheet.Range["A3"].Text = "Enter a Number";

validation1.AllowType = ExcelDataType.Integer;

validation1.CompareOperator = ExcelDataValidationComparisonOperator.Between;

validation1.FirstFormula = "0";

validation1.SecondFormula = "10";

validation1.ShowErrorBox = true;

validation1.ErrorBoxText = "Enter Value between 0 to 10";

validation1.ErrorBoxTitle = "ERROR";

validation1.PromptBoxText = "Data Validation using Condition for Numbers";

validation1.ShowPromptBox = true;

'Data Validation for Numbers
        Dim validation1 As IDataValidation = sheet.Range("A3").DataValidation
        sheet.Range("A3").Text = "Enter a Number"
        validation1.AllowType = ExcelDataType.Integer
        validation1.CompareOperator = ExcelDataValidationComparisonOperator.Between
        validation1.FirstFormula = "0"
        validation1.SecondFormula = "10"
        validation1.ShowErrorBox = True
        validation1.ErrorBoxText = "Enter Value between 0 to 10"
        validation1.ErrorBoxTitle = "ERROR"
        validation1.PromptBoxText = "Data Validation using Condition for Numbers"
        validation1.ShowPromptBox = True

Did you find this information helpful?

Yes

Comments (0)

Please sign in to leave a comment