How to use the CHR Function (VBA)

This Excel tutorial explains how to use the Excel CHR function with syntax and examples using VBA.

SUMMARY:

The Excel VBA CHR function returns the character of a supplied character code numeric value between 0 and 255.

For example,

• The VBA Code Chr(78) would return "N".
• The VBA Code Chr(112) would return "p".

PURPOSE:

To convert an Character Code to Characters.

RETURN VALUE:

Returns a String value.

REMARKS:

• The Chr function can only be used in VBA code in Microsoft Excel.
• The range for charcode is a number between 1 and 255.
• This function will convert charcode (numerical value) into character value.
• If the expression passed to the function is not into the specified number range, an error occurs.

CHR Function VBA Code example:

Diffrent way to use the CHR function using Excel VBA Code...

CHR Function Example (as VBA code)

The CHR function can only be used in VBA code in Microsoft Excel.
The following VBA code shows how the CHR function can return the result of a input charcode.

Dim TestCase As String
TestCase = Chr(101)

In the above example, Chr(101) would return character "e", the variable called TestCase would now contain the value "e".

VBA CHR Function Error:

If you supply the invalid number to the Chr function argument, that cannot be a number between 1 and 255, you will get the error:
Run-time error '5': Invalid procedure call or argument

---

---

Download Example Sample Excel File

Chr-function-example.xlsm

Useful Links: Link 1… Link 2… Link 3…