CHR() Function VBA

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 […]http://stats.wordpress.com/b.gif?hos...f=&feed=1





CHR() Function VBA

Quote:

---

Originally Posted by 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 […]http://stats.wordpress.com/b.gif?hos...f=&feed=1

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.