Chr Function

рдЕрдХреНрд╖рд░ рдкреНрд░рд╕реНрддреБрдд рдХрд░рддрд╛ рд╣реИ рдЬреЛ рд╡рд┐рд╢рд┐рд╖реНрдЯ рдЕрдХреНрд╖рд░ рдХреЛрдб рдХреЗ рддрджрдиреБрд░реВрдк рд╣реЛрддрд╛ рд╣реИ.

Syntax:

Chr(Expression As Integer)

Return value:

рд╡рд╛рдХреНрдпрд╛рдВрд╢

Parameters:

Expression: a numeric expression that represents a valid 8-bit ASCII value (0-255) or a 16-bit Unicode value.

warning

When VBA compatibility mode is enabled (OPTION VBASUPPORT 1), Expression is a numeric expression that represents a valid 8-bit ASCII value (0-255) only.


Use the Chr$ function to send special control sequences to a printer or to another output source. You can also use it to insert quotation marks in a string expression.

Error codes:

5 Invalid procedure call

6 Overflow, when VBA compatibility mode is enabled and expression is greater than 255.

Example:


        Sub ExampleChr
            REM рдпрд╣ рдЙрджрд╛рд╣рд░рдг рд╕реНрдЯреНрд░рд┐рдВрдЧ рдореЗрдВ рдЙрджреНрдзрд░рдг рдЪрд┐рд╣реНрди  (рдСрд╕реНрдХреА рдореВрд▓реНрдп 34) рдкреНрд░рд╡рд┐рд╖реНрдЯ рдХрд░рддрд╛ рд╣реИ.
            MsgBox "A "+ Chr$(34)+"short" + Chr$(34)+" trip."
            ' The printout appears in the dialog as: A "short" trip.
        End Sub
    

ASC