Passing A String Value to A Worksheet Cell

[Chubski]

Hello,

Can you let me know if there is an easy way to paste as text a String's value or amalgamtion of two or three Strings into a cell on a worksheet as text?

I've used the String to change the label on a userform but also need to paste it into a specific cell.

I've searched through the site but can't see anything that is straightforward.

Regards

Chubski

 

[VoG]

Try like this

With UserForm1
    Sheets("Sheet3").Range("A1").Value = .Label1.Caption & .Label2.Caption & .Label3.Caption
End With

 

[Chubski]

Hi Peter,

Thanks very much. That worked a treat and helps me with something else also.

Regards

C