CompareMode Property
Sets and returns the comparison mode for comparing string keys in a Dictionary object.
object.CompareMode[ = compare]
Arguments
object
Required. Always the name of a Dictionary object.
compare
Optional. If provided, compare is a value representing the comparison mode used by functions such as StrComp.
Settings
The compare argument has the following settings:
| Constant |
Value |
Description |
| vbBinaryCompare |
0 |
Perform a binary comparison. |
| vbTextCompare |
1 |
Perform a textual comparison. |
Remarks
Values greater than 2 can be used to refer to comparisons using specific Locale IDs (LCID). An error occurs if you try to change the comparison mode of a Dictionary object that already contains data.
The CompareMode property uses the same values as the compare argument for the StrComp function.
The following example illustrates use of the CompareMode property:
Dim d
Set d = CreateObject("Scripting.Dictionary")
d.CompareMode = vbTextCompare
d.Add "a", "Athens" ' Add some keys and items.
d.Add "b", "Belgrade"
d.Add "c", "Cairo"
d.Add "B", "Baltimore" ' Add method fails on this line because the
' letter b already exists in the Dictionary.
See Also
Count Property | Item Property | Key Property
Applies To: Dictionary Object
| 
