Signature (Visual Basic / VBA)
Public Function SortOrderMatchingCharacterPairs( _
Optional ByVal vCompare As Variant _
) As String
Code Example
SortOrderMatchingCharacterPairs(vbBinaryCompare) = ""
SortOrderMatchingCharacterPairs(vbTextCompare) = "...AaBbCcDdEeFf..."
Parameters
| Parameter | Description |
|---|---|
| vCompare | Specifies the sort order/collating sequence in which pairs characters matching characters are to be located. vCompare defaults to Binary comparisons if it is missing or Null or cannot be fixed up to a number; in the Binary collating sequence, no two characters match, so the function will return an empty string. |
Notes & Version History
| Note | The results of example #2 has been condensed with "..." to save space. |
| Note | Function currently only works for characters whose ASCII value is between 0 and 255, so it does NOT support UNICODE. |