CHR() Function VBA

[Transformer]

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

[Rick Rothstein]

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.