change font to bold and size when transferring from userform to sheet

[Mikeymike_W]

Hi,

I have a userform, i have it set up to tranfer details from the userform to a sheet within the same workbook.
I was wondering how i would go about changing the font to bold and change the font size of Label1.caption once it is transferred to the sheet?

Many thanks for your help,

Mike

Sheets("12 Month").Shapes("TBQA1").OLEFormat.Object.Text = Label1.Caption & vbNewLine & vbNewLine & TextBox2.Value & vbNewLine & TBDisc1.Value

 

[Mikeymike_W]

Sorry, just ignore me, it turns out I forgot to delete some old code, now I have your code is working a charm.

Thank you Norrie!

 

[Norie]

Can you post exactly what you tried?