Modify Method

Modifies existing data validation for a range of cells using the specified options.

[Visual Basic]
Overridable Sub Modify( _
   ByVal type As ValidationType, _
   ByVal alertStyle As ValidationAlertStyle, _
   ByVal validationOperator As ValidationOperator, _
   ByVal formula1 As String, _
   ByVal formula2 As String _
) 

[C#]
virtual void Modify( 
   ValidationType type,
   ValidationAlertStyle alertStyle,
   ValidationOperator validationOperator,
   string formula1,
   string formula2
);

[C++]
virtual void Modify( 
   ValidationType type,
   ValidationAlertStyle alertStyle,
   ValidationOperator validationOperator,
   string* formula1,
   string* formula2
) 

[C++/CLI]
virtual void Modify( 
   ValidationType type,
   ValidationAlertStyle alertStyle,
   ValidationOperator validationOperator,
   String^ formula1,
   String^ formula2
) 

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

Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family

See Also

IValidation Interface  | IValidation Members

See our live Excel Reporting, Excel Charting, Excel to DataGrid and Excel Calculation Samples.

Copyright © 2003-2007 SpreadsheetGear LLC. All Rights Reserved.

SpreadsheetGear and Spreadsheet Gear are trademarks of SpreadsheetGear LLC.