Excel VBA changing color for CommandButton

Question

I'm having problem with changing colors of my CommandButton. In the spreadsheet I add design button as form or ActiveX.

Then in VBA I try:

Activesheet.shapes("CommandButton1").visible = false

This one works just fine.

But then I try:

Activesheet.shapes.Fill.ForeColor.RGB = RGB(220, 105, 0)

It runs without error but nothing changes; color remains as it was before.

Could you please help me with this?

Shapes is a collection, you need to specify which index you're working with. Also, forms and activex controls are wildly different, and don't work the same at all. — Mathieu Guindon
– Mathieu Guindon, Commented Feb 20, 2017 at 18:44

pokemon_Man · Accepted Answer · 2017-02-20 17:24:25Z

8

Just try it like this:

ActiveSheet.CommandButton1.BackColor = RGB(220, 105, 0)

answered Feb 20, 2017 at 17:10

pokemon_Man

9021 gold badge11 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Ye it works after i add Activesheet.CommandButton1.BackColor = RGB(220, 105, 0). I should have tried it before. Thanks