Validation.Add Method

Adds data validation to the specified range.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Sub Add ( _
    Type As XlDVType, _
    AlertStyle As Object, _
    Operator As Object, _
    Formula1 As Object, _
    Formula2 As Object _
)
'Usage
Dim instance As Validation
Dim Type As XlDVType
Dim AlertStyle As Object
Dim Operator As Object
Dim Formula1 As Object
Dim Formula2 As Object

instance.Add(Type, AlertStyle, Operator, _
    Formula1, Formula2)

void Add(
    XlDVType Type,
    Object AlertStyle,
    Object Operator,
    Object Formula1,
    Object Formula2
)

Parameters

• Type
  Type: Microsoft.Office.Interop.Excel.XlDVType

  Required XlDVType. The validation type.

• AlertStyle
  Type: System.Object

  Optional Object. The validation alert style. Can be one of the following XlDVAlertStyle constants: xlValidAlertInformation, xlValidAlertStop, or xlValidAlertWarning.

• Operator
  Type: System.Object

  Optional Object. The data validation operator. Can be one of the following XlFormatConditionOperator constants: xlBetween, xlEqual, xlGreater, xlGreaterEqual, xlLess, xlLessEqual, xlNotBetween, or xlNotEqual.

• Formula1
  Type: System.Object

  Optional Object. The first part of the data validation equation.

• Formula2
  Type: System.Object

  Optional Object. The second part of the data validation when Operator is xlBetween or xlNotBetween (otherwise, this argument is ignored).

Remarks

The Add method requires different arguments, depending on the validation type, as shown in the following table.

See Also

Reference

Validation Interface

Validation Members

Microsoft.Office.Interop.Excel Namespace