ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Can I change the format of a control at Runtine? (https://www.excelbanter.com/excel-programming/409646-can-i-change-format-control-runtine.html)

[email protected]

Can I change the format of a control at Runtine?
 
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

Mark Ivey[_2_]

Can I change the format of a control at Runtine?
 
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



All times are GMT +1. The time now is 05:18 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com