Share via


Operator Property [Excel 2003 VBA Language Reference]

Operator property as it applies to the Filter object.

XlAutoFilterOperator

XlAutoFilterOperator can be one of these XlAutoFilterOperator constants.
xlAnd
xlBottom10Percent
xlTop10Items
xlBottom10Items
xlOr
xlTop10Percent

expression.Operator

expression Required. An expression that returns one of the above objects.

Operator property as it applies to the FormatCondition and Validation objects.

Returns the operator for the conditional format or data validation. Read-only Long.

expression.Operator

expression Required. An expression that returns one of the above objects.

Example

As it applies to the FormatCondition object.

This example changes the formula for conditional format one, for cells E1:E10 if the formula specifies "less than 5."

With Worksheets(1).Range("e1:e10").FormatConditions(1)
    If .Operator = xlLess And .Formula1 = "5" Then
        .Modify xlCellValue, xlBetween, "5", "15"
    End If
End With

Applies to | Filter Object | FormatCondition Object | Validation Object

See Also | Formula1 Property | Formula2 Property