Chr, ChrB, ChrW

Returns a String containing the character associated with the specified character code.

Syntax:

  • Chr$( charcode ), Chr( charcode )
  • ChrB$( charcode ), ChrB( charcode )
  • ChrW$( charcode ), ChrW( charcode )
charcode
required A Long that identifies a character.

The $-suffixed forms return a String; the unsuffixed forms return a Variant (String).

Numbers from 0–31 are the same as standard, nonprintable ASCII codes. For example, Chr(10) returns a linefeed character. The normal range for charcode is 0–255. However, on DBCS systems, the actual range for charcode is -32768–65535.

Note

The ChrB function is used with byte data contained in a String. Instead of returning a character, which may be one or two bytes, ChrB always returns a single byte. The ChrW function returns a String containing the Unicode character.

The functions Asc, AscB, and AscW are the opposite of Chr, ChrB, and ChrW. The Asc functions convert a string to an integer.

Example

This example uses the Chr function to return the character associated with the specified character code.

Dim MyChar
MyChar = Chr(65)    ' Returns A.
MyChar = Chr(97)    ' Returns a.
MyChar = Chr(62)    ' Returns >.
MyChar = Chr(37)    ' Returns %.

See Also

License: CC-BY-4.0 Code license: MIT Attribution: VBA-Docs