'Declaration
 
Function Add( _
   ByVal type As DataValidationType, _
   Optional ByVal errorStyle As DataValidationErrorStyle, _
   Optional ByVal operator As DataValidationOperator, _
   Optional ByVal formula1 As String, _
   Optional ByVal formula2 As String _
) As IValidation

'Usage
 
Dim instance As IValidation
Dim type As DataValidationType
Dim errorStyle As DataValidationErrorStyle
Dim operator As DataValidationOperator
Dim formula1 As String
Dim formula2 As String
Dim value As IValidation
 
value = instance.Add(type, errorStyle, operator, formula1, formula2)

IValidation Add( 
   DataValidationType type,
   DataValidationErrorStyle errorStyle,
   DataValidationOperator operator,
   string formula1,
   string formula2
)

Parameters

type

A DataValidationType value indicates the type of data validation to add.

errorStyle

A DataValidationErrorStyle value indicates the error style to use for error messages.

operator

A DataValidationOperator value indicates the data validation operator.

formula1

A string value indicates the first data validation value, formula or list.

formula2

A string value indicates the second data validation value for DataValidationOperator.Between or DataValidationOperator.NotBetween.

Return Value

Reference

IValidation Interface
IValidation Members