SpreadsheetGear 2017
Modify Method (IValidation)






SpreadsheetGear Namespace > IValidation Interface : Modify Method
Specifies the new type of data validation.
Specifies the alert style to use for alert messages.
Specifies the new data validation operator.
Specifies the first data validation value, formula or list.
Specifies the second data validation value for ValidationOperator.Between or ValidationOperator.NotBetween.
Modifies existing data validation for a range of cells using the specified options.
Syntax
'Declaration
 
Sub Modify( _
   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.Modify(type, alertStyle, validationOperator, formula1, formula2)
procedure Modify( 
    type: ValidationType;
    alertStyle: ValidationAlertStyle;
    validationOperator: ValidationOperator;
    formula1: System.String;
    formula2: System.String
); 
function Modify( 
   type : ValidationType,
   alertStyle : ValidationAlertStyle,
   validationOperator : ValidationOperator,
   formula1 : System.String,
   formula2 : System.String
);

Parameters

type
Specifies the new type of data validation.
alertStyle
Specifies the alert style to use for alert messages.
validationOperator
Specifies the new 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