CHR(charcode)

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

charcode

The number that identifies a character (Long).

REMARKS

* This function can be used to return both printable and unprintable characters.
* Numbers from 0 - 31 are the same as standard, nonprintable ASCII codes.
* For example, Chr(10) returns a linefeed character.
* The normal range for number is 0 - 255.
* If "charcode" > 256, then a run-time error is generated.
* You can use the ASC function to return the ANSI 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 a String containing the corresponding Unicode character.
* You can use the CHRW$ function return a String data type instead of a Variant data type.
* The equivalent Excel function is Application.WorksheetFunction.CHAR
* The equivalent .NET function is Microsoft.VisualBasic.Strings.Chr
* 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"  

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