ChrW Function [VBA]

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

warning

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


Syntax:


ChrW(Expression As Integer)

Return value:

String

Parameters:

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 μ˜€λ²„ν”Œλ‘œμš°κ°€ λ°œμƒν–ˆμŠ΅λ‹ˆλ‹€.

Example:


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