Articles in this section
Category / Section

How to set data validation for numbers?

1 min read

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

C#

// 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;

 

 

VB

'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
No
Help us improve this page
Please provide feedback or comments
Comments (0)
Please sign in to leave a comment
Access denied
Access denied