I'm not completely sure of your question; see if this answers it. These are
predefined constants in
VB... vbCr is a Carriage Return character (ASCII
13), vbLf is a Line Feed character (ASCII 10) and vbCrLf is two
characters... a Carriage Return followed by a Line Feed. You can think of
this last one like this...
vbCrLf <== vbCr & vbLf
Generally, for text files, the vbLf character is used as the "newline"
character in UNIX and Linux operating systems; the vbCr character is used as
the "newline" character in Mac computers and the vbCrLf combination of
characters is used as the "newline" character sequence in Windows systems.
For whatever reason, Microsoft decided to use vbLf for "newlines" in Excel
cell text, MessageBoxes, Labels, etc., contrary to their own established
vbCrLf convention used in Windows text files.
--
Rick (MVP - Excel)
"Alberto Ast" wrote in message
...
Thanks it works great but I have one question...
What is the difference among
vbCr, vbCrLf and vbLf?
"Rick Rothstein" wrote:
Try concatenating vbLf between them...
Me.Label5 = Range("e12").Value & vbLf & Range("e13").Value
--
Rick (MVP - Excel)
"Alberto Ast" wrote in message
...
I have a userform label set to a specific value copied from two cells..
can
I
have an enter betwen both cells value?
Me.Label5 = Range("e12").Value & Range("e13").Value
I would like it to show
ECR
123456
where
ECR is the value in cell c12
123456 is the value in cell e13
it actualy shows
ECR123456
.