Miscellaneous Constants

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

The following constants are defined in the Visual Basic for Applications type library and can be used anywhere in your code in place of the actual values:

Constant

Equivalent

Description

vbCrLf

Chr(13) + Chr(10)

Carriage return–linefeed combination

vbCr

Chr(13)

Carriage return character

vbLf

Chr(10)

Linefeed character

vbNewLine

Chr(13) + Chr(10) or, on the Macintosh, Chr(13)

Platform-specific new line character; whichever is appropriate for current platform

vbNullChar

Chr(0)

Character having value 0

vbNullString

String having value 0

Not the same as a zero-length string (""); used for calling external procedures

vbObjectError

-2147221504

User-defined error numbers should be greater than this value. For example:
Err.Raise Number = vbObjectError + 1000

vbTab

Chr(9)

Tab character

vbBack

Chr(8)

Backspace character

vbFormFeed

Chr(12)

Not useful in Microsoft Windows or on the Macintosh

vbVerticalTab

Chr(11)

Not useful in Microsoft Windows or on the Macintosh

Show: