Partager via


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.

See Also

Reference

Microsoft.Office.Interop.Excel Namespace