Options Buttons from FORMS and CONTROL TOOLBOX menus

To change a form button, Right click the button, select format, then font options. Note the best way to format a form button is to edit text delete all the text then right click the blank button and format the font then re-type the lable.

The VB code to change one button is not a problem but to change 200 all diffetent buttons is a waist of programming time it would be faster to just do each button, as it is a one-shot thing anyway!

The VB code syntax is different for a control button and a form button. If you write a working macro for a form button in most cases it will not work on a control button and must be totally re-written as even the logic would need changing some methods and functions are not supported by control buttons. In short use form buttons. Use control buttons only on user forms and only when you must. JSW

Joe,

I cant still change the color and font of the Option Button from FORMS. I am talking about the Option Button label that reads Option Button1 when you drag a new option button from FROMS.

Formatting doesnt apply to the text.

thank
-al

If you are talking about an option button on a UserForm, you do not do it with code;
Select the button on the userform Right cklick it select properties (your VB editor must be set to display the properties window) on the list is Font click in the box to the right of it, then select the code button to the right and select the font. Most of the other options work the same way. JSW Joe, I cant still change the color and font of the Option Button from FORMS. I am talking about the Option Button label that reads Option Button1 when you drag a new option button from FROMS. Formatting doesnt apply to the text. thank

Joe,

Im talking about the OptionButton you drag on the excel page (not VB) from the FORMS toolbar.

thanks

-al If you are talking about an option button on a UserForm, you do not do it with code;