XlDVType Enumeration
Specifies the type of validation test to be performed in conjunction with values.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Public Enumeration XlDVType
'Usage
Dim instance As XlDVType
public enum XlDVType
Members
| Member name | Description | |
|---|---|---|
| xlValidateInputOnly | Only validate when user changes the value. | |
| xlValidateWholeNumber | Whole numeric values. | |
| xlValidateDecimal | Numeric values. | |
| xlValidateList | Value must be present in a specified list. | |
| xlValidateDate | Date values. | |
| xlValidateTime | Time values. | |
| xlValidateTextLength | Length of text. | |
| xlValidateCustom | Data is validated using an arbitrary formula. |