PDA

View Full Version : CHR() Function VBA



Transformer
05-17-2013, 12:32 AM
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?host=usefulgyaan.wordpress.com&blog=50473542 &post=662&subd=usefulgyaan&ref=&feed=1





CHR() Function VBA (http://usefulgyaan.wordpress.com/2013/05/10/chr-function-vba/)

Rick Rothstein
05-20-2013, 08:50 AM
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?host=usefulgyaan.wordpress.com&blog=50473542 &post=662&subd=usefulgyaan&ref=&feed=1

CHR() Function VBA (http://usefulgyaan.wordpress.com/2013/05/10/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.