Category / Section
How to set data validation for Date?
1 min read
Use the following code snippets to set data validation for date.
C#
//Data Validation for Date IDataValidation validation = sheet.Range["A5"].DataValidation; sheet.Range("A5").Text = "Enter the Date"; validation2.AllowType = ExcelDataType.Date; validation2.CompareOperator = ExcelDataValidationComparisonOperator.Between; validation2.FirstDateTime = New DateTime(2003, 5, 10); validation2.SecondDateTime = New DateTime(2004, 5, 10); validation2.ShowErrorBox = True; validation2.ErrorBoxText = "Enter Value between 10/5/2003 to 10/5/2004"; validation2.ErrorBoxTitle = "ERROR"; validation2.PromptBoxText = "Data Validation using Condition for Date"; validation2.ShowPromptBox = True;
VB
'Data Validation for Date Dim validation2 As IDataValidation = sheet.Range("A5").DataValidation sheet.Range("A5").Text = "Enter the Date" validation2.AllowType = ExcelDataType.Date validation2.CompareOperator = ExcelDataValidationComparisonOperator.Between validation2.FirstDateTime = New DateTime(2003, 5, 10) validation2.SecondDateTime = New DateTime(2004, 5, 10) validation2.ShowErrorBox = True validation2.ErrorBoxText = "Enter Value between 10/5/2003 to 10/5/2004" validation2.ErrorBoxTitle = "ERROR" validation2.PromptBoxText = "Data Validation using Condition for Date" validation2.ShowPromptBox = True