MsoFilterComparison enumeration (Office)
Specifies how the Column and CompareTo properties are compared for an ODSOFilter object.
| Name | Value | Description |
|---|---|---|
| msoFilterComparisonContains | 8 | Column matches CompareTo if any part of the CompareTo string is contained in the Column value. |
| msoFilterComparisonEqual | 0 | Column matches CompareTo if the CompareTo value is the same as the Column value. |
| msoFilterComparisonGreaterThan | 3 | Column matches CompareTo if the Column value is greater than the CompareTo value. |
| msoFilterComparisonGreaterThanEqual | 5 | Column matches CompareTo if the Column value is greater than or equal to the CompareTo value. |
| msoFilterComparisonIsBlank | 6 | Column passes filter if Column is blank. |
| msoFilterComparisonIsNotBlank | 7 | Column passes filter if Column is blank. |
| msoFilterComparisonLessThan | 2 | Column matches CompareTo if the Column value is less than the CompareTo value. |
| msoFilterComparisonLessThanEqual | 4 | Column matches CompareTo if the Column value is less than or equal to the CompareTo value. |
| msoFilterComparisonNotContains | 9 | Column matches CompareTo if any part of the CompareTo string is not contained in the Column value. |
| msoFilterComparisonNotEqual | 1 | Column matches CompareTo if the CompareTo value is not equal to the Column value. |
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.