Can I change the format of a control at Runtine?

G

Guest

Is there any way change the format of a control at Runtine? If so, how do
I specift Font, font size, type (Bold, etc)

Thanks for any help
 
M

Mark Ivey

What type of control do you want changed?

What name have you given it?

Mark Ivey


Here is a basic example showing how you can change a commandbutton's
features when the userform initializes...


Private Sub UserForm_Initialize()

CommandButton1.Font.Bold = True
CommandButton1.Font.Size = 26

End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Remove Hyperlinks Without Changing background shading 14
Format in text boxes with multiple text lines 1
More than 3 Conditional Formals - EXCEL 2000 10
Label controls change apparent font size when moved up/down 3
Format font of text in a message box 4
Can you change the font and font size for a forms control ? 4
Conditional formatting limit to 3 Excel 2003 5
MsgBox String Formatting Change 1

Top