I used constants like vbLf
, vbCrLf
& vbCr
in a MsgBox; it produces same output in a MsgBox (Text "Hai" appears in a first paragraph and a word "Welcome" appears in a next Paragraph )
MsgBox("Hai" & vbLf & "Welcome") MsgBox ("Hai" & vbCrLf & "Welcome") MsgBox("Hai" & vbCr & "Welcome")
I know vbLf
, vbCrLf
& vbCr
are used for print and display functions.
I want to know the Difference between the vbLf
, vbCrLf
& vbCr
constants.
Vbcrlf is a combination of the two actions explained above: the Carriage Return (VbCr) that moves the cursor back to the beginning of the line and the Line feed (VbLf) that moves the cursor position down one line. In other words, vbCrLf is to VBA what the ENTER key is to a word processor.
vbCr : - return to line beginning. Represents a carriage-return character for print and display functions. vbCrLf : - similar to pressing Enter. Represents a carriage-return character combined with a linefeed character for print and display functions. vbLf : - go to next line.
vbLf Field (Microsoft. VisualBasic) Represents a linefeed character for print and display functions.
Constant Value Description ---------------------------------------------------------------- vbCr Chr(13) Carriage return vbCrLf Chr(13) & Chr(10) Carriage return–linefeed combination vbLf Chr(10) Line feed
vbCr : - return to line beginning
Represents a carriage-return character for print and display functions.
vbCrLf : - similar to pressing Enter
Represents a carriage-return character combined with a linefeed character for print and display functions.
vbLf : - go to next line
Represents a linefeed character for print and display functions.
Read More from Constants Class
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With