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

.