Version

DataValidationCriteria Enumeration

Determines what types of cell values are allowed and how the cell value is validated against the constraint(s).
Syntax
'Declaration
 
Public Enum DataValidationCriteria 
   Inherits System.Enum
public enum DataValidationCriteria : System.Enum 
Members
MemberDescription
DateDates with or without time portions are allowed as well as numbers equivalent to valid dates. When comparing against constraints, the cell value is used.
DecimalOnly numbers are allowed. When comparing against constraints, the cell value is used.
TextLengthNon-error values are allowed. When comparing against constraints, the length of the cell value's text equivalent is used.
TimeTimes are allowed are well as numbers equivalent to valid times without a date portion. When comparing against constraints, the cell value is used.
WholeNumberOnly numbers are allowed and they cannot have a fractional part. When comparing against constraints, the cell value is used.
Requirements

Target Platforms: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also