One more way for interest, if the cells are contiguous -

Dim dObj As DataObject
Set dObj = New DataObject
Range("A1:C3").Copy

dObj.GetFromClipboard
Me.Label1 = dObj.GetText(1)
Application.CutCopyMode = False

If only a few cells or non-contiguous stick with what you've got.

Regards,
Peter T



"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