The following table shows the string constants you can use anywhere in your code in place of actual values.
Constant |
Value |
Description |
vbCr | Chr(13) | Carriage return |
vbCrLf | Chr(13) & Chr(10) | Carriage return–line feed combination |
vbFormFeed | Chr(12) | Form feed; not useful in Microsoft Windows |
vbLf | Chr(10) | Line feed |
vbNewLine | Chr(13) & Chr(10) or Chr(10) | Platform-specific newline character, as appropriate for the platform |
vbNullChar | Chr(0) | Character having the value 0 |
vbNullString | String having value 0 | Not the same as a zero-length string (""); used for calling external procedures |
vbTab | Chr(9) | Horizontal tab |
vbVerticalTab | Chr(11) | Vertical tab |