CHR

CHR(charcode)

Returns the character with the corresponding ASCII / ANSI number (Variant / String).

charcode

The number that identifies a character (Long).

REMARKS

* The value returned is in the range 0 to 255.
* This function can be used to return both printable and unprintable characters.
* The ASCII Character codes use the values 0 to 127.
* The ANSI Character codes use the values 0 to 255.
* If "charcode" < 32, then non printable ASCII codes are returned.
* If "charcode" = 10, then a linefeed character is returned.
* If "charcode" > 256, then a run-time error is generated.
* You can use the ASC function to return the ASCII / ANSI number for the first character in a text string.
* You can use the ASCW function to return the Unicode number for the first character in a text string.
* You can use the CHR$ function to return a String data type instead of a Variant data type.
* You can use the CHRB function is used with byte data contained in a String.
* You can use the CHRB$ function to return a String data type instead of a Variant data type.
* You can use the CHRW function to return the character with the corresponding Unicode number.
* The equivalent Excel function is Application.WorksheetFunction.CHAR
* The equivalent .NET function is [[Microsoft.VisualBasic.Strings.Chr]]
* For more information, refer to the ANSI Characters page.
* For the Microsoft documentation refer to learn.microsoft.com

Debug.Print Chr(9)           '= tab  
Debug.Print Chr(10)          '= line feed  
Debug.Print Chr(13)          '= carriage return  
Debug.Print Chr(32)          '= space  
Debug.Print Chr(65)          '= "A"  
Debug.Print Chr(70)          '= "F"  
Debug.Print Chr(90)          '= "Z"  
Debug.Print Chr(97)          '= "a"  
Debug.Print Chr(122)         '= "z"  
Debug.Print Chr(150)         '= Em Dash  
Debug.Print Chr(151)         '= En Dash  

Dim lCode As Long 
lCode = Chr(100)             '= "d"  
Debug.Print lCode 

Debug.Print Chr(Asc("A"))    '= "a"