Button (Form control)

[lezawang]

Hi
I inserted Buttons to run some macros. I wonder, can I change the color of these buttons? Like red, green etc. I can only change the text (label) but no option to change the color itself. Thank you so much.

 

[eikogs]

Go to properties of the button and change the "BackColor" property. Click the palette tab on to get more color options.

 

[lezawang]

How to go to properties? Right click did not give me that choice. Right click-->Format Control then there is a tab to change font color not the button. Thank you.

 

[jproffer]

A forms button's color can't be changed (in XL13 version at least). BUT, you can Insert Tab-Insert Shape-whatever shape you want, and they can be changed to almost anything you want, and you can assign a macro to the shape.

 

[eikogs]

Sorry, I mistook "Form Control" for user form. I don't think you can change the color of a form control button directly on a worksheet. You can insert an object instead of the form control button and assign a macro to the object. Go to the insert tab->Shapes and insert a rectangle or other shape of your choice.