AscW Function [VBA]

Returns the Unicode value of the first character in a string expression.

This constant, function or object is enabled with the statement Option VBASupport 1 placed before the executable program code in a module.

Syntax:

AscW (string) As Long

Return value:

Long

Parameters:

string: Any valid string expression. Only the first character in the string is relevant.

Use the AscW function to replace keys with Unicode values. If the AscW function encounters a blank string, Office Basic reports a run-time error. Returned values are between 0 and 65535.

Error codes:

5 Invalid procedure call

Example:

Sub ExampleAscW
 Print AscW("A") ' returns 65
 Print AscW(string:="Ω") ' returns 937
 Print AscW("Αθήνα") ' returns 913, since only the first character (Alpha) is taken into account
End Sub

Related Topics

• Asc Function (BASIC)
• Chr Function
• ChrW Function \[VBA\]