Quote Originally Posted by Transformer View Post
UsefulGyaan Has Posted the Following On 05-10-2013 09:42 PM:

In VBA, we have CHR() function that returns a character based on the ASCII value. Syntax: The syntax for CHR() function is CHR(Ascii_Value) The parameter “Ascii_value” is used to retrieve the character. How to use: Dim chrA***As String ******************************* ChrA=CHR(87) In the above example, chrA will hold a value “W” which is ASCII equivalent to […]

CHR() Function VBA
Yes, if you planned to store the output from the Chr function in a variable, then that variable should be Dim'med as a String data type.