Results 1 to 2 of 2

Thread: CHR() Function VBA

  1. #1
    Member Transformer's Avatar
    Join Date
    Mar 2012
    Posts
    91
    Rep Power
    13

    Lightbulb 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 […]





    CHR() Function VBA

  2. #2
    Forum Guru Rick Rothstein's Avatar
    Join Date
    Feb 2012
    Posts
    662
    Rep Power
    13
    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.

Similar Threads

  1. UDF (user defined function) replacement for Excel's DATEDIF function
    By Rick Rothstein in forum Rick Rothstein's Corner
    Replies: 21
    Last Post: 03-07-2015, 09:47 PM
  2. IsDate() Function : VBA
    By Transformer in forum Tips, Tricks & Downloads (No Questions)
    Replies: 0
    Last Post: 06-03-2013, 10:00 PM
  3. CurDir() function VBA
    By Transformer in forum Tips, Tricks & Downloads (No Questions)
    Replies: 0
    Last Post: 05-17-2013, 12:32 AM
  4. STRCONV Function (VBA)
    By Transformer in forum Tips, Tricks & Downloads (No Questions)
    Replies: 0
    Last Post: 05-17-2013, 12:32 AM
  5. FindAll Function In VBA
    By Admin in forum Excel and VBA Tips and Tricks
    Replies: 4
    Last Post: 02-19-2012, 04:11 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •