View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Alberto Ast[_2_] Alberto Ast[_2_] is offline
external usenet poster
 
Posts: 181
Default userform label set enter

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