LibreOffice 7.6 Help
āĻāϞā§āϞā§āĻāĻŋāϤ āĻ āĻā§āώāϰ āĻā§āĻĄ āϏāĻāĻļā§āϞāĻŋāώā§āĻ āĻ āĻā§āώāϰ āĻĒā§āϰāĻĻāĻžāύ āĻāϰ⧠āĻĨāĻžāĻā§āĨ¤
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 "short" trip āĻšāĻŋāϏā§āĻŦā§ āĻāĻŦāĻŋāϰā§āĻā§āϤ āĻšā§āĨ¤
MsgBox Chr(charcode := 64) ' "@" sign
End Sub