ChrW Function [VBA]

Returns the Unicode character that corresponds to the specified character code.


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


ChrW(Expression As Integer)

Return value:



Expression: Numeric variables that represent a valid 16 bit Unicode value (0-65535). (To support expressions with a nominally negative argument like ChrW(&H8000) in a backwards-compatible way, values in the range βˆ’32768 to βˆ’1 are internally mapped to the range 32768 to 65535.) An empty value returns error code 5. A value out of the range [0,65535] returns error code 6.

Error codes:

5 αž€αžΆαžšβ€‹αž αŸ…β€‹αž”αŸ‚αž”αž”αž‘β€‹αž˜αž·αž“β€‹αžαŸ’αžšαžΉαž˜αžαŸ’αžšαžΌαžœ

6 αž›αžΎαžŸβ€‹αž…αŸ†αžŽαž»αŸ‡


Sub ExampleChrW
 ' This example inserts the Greek letters alpha and omega in a string.
 MsgBox "From "+ ChrW(913)+" to " + ChrW(937)
 ' The printout appears in the dialog as: From Ξ‘ to Ξ©
End Sub

Please support us!