SpreadsheetGear 2023
Add Method (IValidation)


SpreadsheetGear Namespace > IValidation Interface : Add Method
Specifies the type of data validation to add.
Specifies the alert style to use for alert messages.
Specifies the data validation operator.
Specifies the first data validation value, formula or list.
Specifies the second data validation value for ValidationOperator.Between or ValidationOperator.NotBetween.
Adds data validation to a range of cells using the specified options.
Syntax
'Declaration
 
Sub Add( _
   ByVal type As ValidationType, _
   ByVal alertStyle As ValidationAlertStyle, _
   ByVal validationOperator As ValidationOperator, _
   ByVal formula1 As System.String, _
   ByVal formula2 As System.String _
) 
'Usage
 
Dim instance As IValidation
Dim type As ValidationType
Dim alertStyle As ValidationAlertStyle
Dim validationOperator As ValidationOperator
Dim formula1 As System.String
Dim formula2 As System.String
 
instance.Add(type, alertStyle, validationOperator, formula1, formula2)

Parameters

type
Specifies the type of data validation to add.
alertStyle
Specifies the alert style to use for alert messages.
validationOperator
Specifies the data validation operator.
formula1
Specifies the first data validation value, formula or list.
formula2
Specifies the second data validation value for ValidationOperator.Between or ValidationOperator.NotBetween.
Requirements

Target Platforms: 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

Reference

IValidation Interface
IValidation Members