Validation Methods

Name

Returns

Parameters

Description

XlDVType,

[Alert

Style],

[Operator],

[Formulai],

[Formula2]

Adds data validation to the parent range. The validation type (Type parameter) must be specified. The type of validation alert (AlertStyle) can be specified with the XlDVAlertStyle constants. The Operator parameter uses the XlFormatCondition Operator to pick the type of operator to use. The Formulai and Formula2 parameters pick the data validation formula

Delete

Deletes the Validation method for the range

[AlertStyle], [Operator], [Formulai], [Formula2]

Modifies the properties associated with the Validation. See the properties of the Validation object for a description of the parameters

0 0

Post a comment