userform label set enter
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
|