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.

Reference