MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Options Buttons from FORMS and CONTROL TOOLBOX menus


Posted by Al on December 27, 2001 5:14 AM

Hi there,

1) Is there any way to change the the text color of the OPTIONS BUTTON from FORMS menu w/o VBA ? if so how a simple VBA would change ~200 options buttons ?

2) Is there any way (w/ or w/o VBA) to force OPTIONS BUTTON from CONTROL TOOLBOX behave like the one from FORMS, in other words, I want Options Button (from control toolbox) spit 1,2,3,4...into the LinkedCell instead of TRUE or FALSE.

-al

thanks


Posted by Joe Was on December 27, 2001 5:27 AM

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

Posted by Al on December 27, 2001 2:37 PM

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


Posted by Joe Was on December 27, 2001 3:25 PM

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


Posted by Al on December 28, 2001 12:24 AM

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;