Sub Modify( _
   ByVal type As ValidationType, _
   ByVal alertStyle As ValidationAlertStyle, _
   ByVal validationOperator As ValidationOperator, _
   ByVal formula1 As String, _
   ByVal formula2 As String _
) 

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.

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

Reference