Signature (Visual Basic / VBA)
Public Function UsedCharacters( _
ByVal vValue As Variant _
) As Variant
Code Example
UsedCharacters("ABBCCC123ABCD") = "ABC123"
UsedCharacters("CCCBBBAAABBBCCC") = "CBA"
Parameters
| Parameter | Description |
|---|---|
| vValue | String containing the characters of which the unique ones will be copied to the result string the first time that appear within string vValue. Function returns Null if vValue is Null or cannot be fixed up to a String. |
Notes & Version History
| Note | Function uses the ASCII value of characters to determine if they match, which is in effect the same as using Binary comparisons. |
| Note | Function currently only works for characters whose ASCII value is between 0 and 255, so it does NOT support UNICODE. |