vbCr vs. vbCrLf (VBA Excel)

[Rudi]

Sub T()
MsgBox "Hello" & vbCr & Application.UserName
MsgBox "Hello" & vbCrLf & Application.UserName
End Sub

vbCrLf, Chr(13) + Chr(10), Carriage return

[AlanMiller]

Cr and Lf are really "legacy" terms, derived from the way mechanical typewriters work - you could either return the carriage without feeding the paper (Cr), feed the paper without moving the carriage (Lf) or do both (CrLf), which is the usual requirement when moving onto the next line of typing. Early printers used the same controls and applications followed suit. As time progressed, the real implications of exactly what kind of Cr/Lf combinations did what became rather blurred. In console-based C programs, they still work like the originals, but for many things it's anyone's guess until you try them out.

In VB, sometimes either/ any will work as CrLf, other times you'll see differences. The reason for the "Sq" and "SqSq" tooltip renderings is because the first is a single character, not displayable in the tooltip, while the latter is two characters.

Alan

[Rudi]

Thx for that clear answer Alan. Question answered!
Cheers

[Howard Kaikow]

CR and LF are "format effectors", as are, e.g., FF and VT.

CR just moves to the beginning of the current line.
LF moves to te next line.

[Rudi]

Tx Howard, appreciate the input!