Constants
Using the VBA Constants
In this tutorial you will learn how to use the VBA Constants.
| Constant | Definition |
|---|
| vbBack | A backspace character [Chr(8)] |
| vbCr | A carriage return [Chr(13)] |
| vbCrLf | A carriage return and line feed [Chr(13) + Chr(10)] |
| vbLf | A linefeed [Chr(10)] |
| vbNewLine | A platform-specific new line character, either [Chr(13) + Chr(10)] or [Chr(13)] |
| vbNullChar | A null character of value 0 [Chr(0)] |
| vbNullString | A string of value 0 [no Chr code]; note that this is not the same as "" |
| vbTab | A tab character [Chr(9)] |
 VBA
Private Sub Form_Load()
vbBack
vbCr
vbCrLf
vbLf
vbNewLine
vbNullChar
vbNullString
vbTab
End Sub
Courses
Want to learn more? Request this via the contact form.
 Search
You can find more about this by searching the website.
By: Alex Hedley
Click here to sign up for more FREE tips
| 
