Set Default Font for all option Buttons

[Howardc1001]

I would like to know if it is at all possible to set a default font setting in the properties for all the option buttons on a userform as well as the backcolor and forecolour


If so, please advise how to do this

[Logit]

.
In the past I have created the first OPTION BUTTON with all the properties set. Then when creating another OPTION BUTTON, I copied the first one and pasted it where needed.


I would presume, if you can GOOGLE for all the properties of an OPTION BUTTON (in VBA CODE), you could utilize the following code in the USERFORM_INITIALIZE event :

Please Login or Register  to view this content.

Keeping in mind the above macro is just an example ... it will need to be edited to fit your specific purposes and it needs to refer to a USERFORM instead of the ACTIVE SHEET.

Hopefully something in this post will provide an incentive to pursue.

[Howardc1001]

Thanks for your input and help in this regard

[Rick Rothstein]

CTRL-click each OptionButton to select them, then use the Properties Window to set the font properties (actually, any available properties) to the values you want.

[Howardc1001]

Thanks for letting me know Rick