VBA to change color of Forms Control Button

[hcgood]

I have a spreadsheet with very simple ActiveX control button to hide, show columns, and some other buttons for other simple purposes.
But my org would like this to run on Mac as well so I'm trying to switch over to Forms Controls. I know little about coding, tho wish I knew more.
I can't believe that after 25 plus years MS still doesn't make this a simple property on the button to make it easy to change!

Can anyone help with some simple VBA code to change the background color of the button to match what I have on the ActiveX button. The color change will be permanent, not contingent on other cells.

I found some code that changes background color on a Checkbox as it is checked or unchecked so it seems the Button color should be able to be changed as well. But can't figure out how to adapt that code for a Button.
Any help would be appreciated. Would like it to have RGB in the code so I can fine tune the color of the button.

Thanks in advance for any help out there.

 

[skillilea]

Are using shapes an option? Insert any kind of shape, you can color/format it as much as you want.
Then just assign a macro to it.

 

[hcgood]

Are using shapes an option? Insert any kind of shape, you can color/format it as much as you want.
Then just assign a macro to it.

Ah, I didn't know I could use Shapes in this way. Will try it!

 

[hcgood]

Ah, I didn't know I could use Shapes in this way. Will try it!

Great, it's working.
May I ask what then is the purpose of the Forms Control Button if the Shape text box seems to be so much more versatile?

 

[skillilea]

Everything has evolved over time. Shapes have gotten better and more versitile. The form/activeX controls are from way back and have not been improved/developed.
Glad it worked. Not sure if you meant text box but you can use rectangles and add icons to it. Group the shape and you have a pretty decent button look.

 

[hcgood]

Everything has evolved over time. Shapes have gotten better and more versitile. The form/activeX controls are from way back and have not been improved/developed.
Glad it worked. Not sure if you meant text box but you can use rectangles and add icons to it. Group the shape and you have a pretty decent button look.

Helpful explanation about 'up and coming' Shapes.
I did mean text box because I needed a title in it, but now, based on what you say about rectangle, I see I can also add a formula to that - fantastic.

Very much appreciate your help.

 

[skillilea]

Glad to help.