Chr Function
āˇāˇāˇāˇāˇāļĢāļē āļāļŊ āļ āļąāˇāļŊāļāˇāļĢāˇ āļāˇāļāļēāļ§ āļ āļąāˇāļģāˇāļ´ āļ āļąāˇāļŊāļāˇāļĢ āļŊāļļāˇ āļ¯āˇāļēāˇ.
Chr[$](charcode As Integer) As String
String
charcode: a numeric expression that represents a valid 8-bit ASCII value (0-255) or a 16-bit Unicode value. (To support expressions with a nominally negative argument like Chr(&H8000) in a backwards-compatible way, values in the range â32768 to â1 are internally mapped to the range 32768 to 65535.)
When VBA compatibility mode is enabled (Option VBASupport 1), charcode is a numeric expression that represents a valid 8-bit ASCII value (0-255) only.
āļ¸āˇāļ¯āˇâāļģāļĢ āļēāļąāˇāļāˇâāļģāļēāļāļ§ āˇāˇ āˇāˇāļąāļāˇ āļ´āˇâāļģāļāˇāļ¯āˇāļą āļ¸āˇāļŊāļēāļāļ§ āˇāˇāˇāˇāˇ āļ´āˇāļŊāļą āļ āļąāˇāļāˇâāļģāļ¸āļĢāļēāļāˇ āļēāˇāˇāˇāļ¸āļ§ Chr$ āļˇāˇāˇāˇāļāˇ āļāļģāļąāˇāļą. āļāļļāļ§ āļāļē āļ āļąāˇ āļŊāļāˇāļĢāˇ āˇāˇāļŊāˇ āļ´āˇâāļģāļāˇāˇāļąāļēāļāļ§ āļāļ¯āˇāļ°āļģāļĢ āļāļāˇāļŊāˇ āļāˇāļģāˇāļ¸āļ§āļ¯ āļˇāˇāˇāˇāļāˇ āļāļŊ āˇāˇāļ.
An overflow error will occur when VBA compatibility mode is enabled and the expression value is greater than 255.
Sub ExampleChr
REM āļ¸āˇāļ¸ āļāļ¯āˇāˇāļģāļĢāļē āļ
āļąāˇ āļŊāļāˇāļĢāˇ āˇāˇāļŊāļ āļāļ¯āˇāļ°āļģāļĢ āļŊāļāˇāļĢāˇ āļāļāˇāļŊāˇ āļāļģāļēāˇ (ASCII āļ
āļāļē 34).
MsgBox "A " + Chr$(34) + "short" + Chr(34) + " trip."
REM āļ¸āˇāļ¯āˇâāļģāļĢ āļ´āˇāļ§āļ´āļ āˇāļāˇāˇāļ¯āļēāļ āļ¸āˇāļŊāˇāˇ āļ´āˇāļąāˇāļēāˇ: A "āļāˇāļ§āˇ" āˇāˇāļąāˇāļ¯ āļ āˇāļģāˇāļāˇāˇāļāˇ.
MsgBox Chr(charcode := 64) ' "@" sign
End Sub