'Declaration
Function Modify( _ ByVal type As DataValidationType, _ Optional ByVal errorStyle As DataValidationErrorStyle, _ Optional ByVal operator As DataValidationOperator, _ Optional ByVal formula1 As String, _ Optional ByVal formula2 As String _ ) As IValidation
'Usage
Dim instance As IValidation Dim type As DataValidationType Dim errorStyle As DataValidationErrorStyle Dim operator As DataValidationOperator Dim formula1 As String Dim formula2 As String Dim value As IValidation value = instance.Modify(type, errorStyle, operator, formula1, formula2)
Parameters
- type
- A DataValidationType value indicates the type of data validation to add.
- errorStyle
- A DataValidationErrorStyle value indicates the error style to use for error messages.
- operator
- A DataValidationOperator value indicates the data validation operator.
- formula1
- A string value indicates the first data validation value, formula or list.
- formula2
- A string value indicates the second data validation value for DataValidationOperator.Between or DataValidationOperator.NotBetween.
Return Value
The modified data validation.
null
if the data validation cannot be modified.