Microsoft Office Forums - View Single Post - [Solved] VBA: How to change color of a CommandButton

Thread: [Solved] VBA: How to change color of a CommandButton

View Single Post

Old

09-25-2016, 11:09 AM

dh1sbg

dh1sbg is offline

dh1sbg uses Windows 10

Windows 10 dh1sbg uses Office 2016

dh1sbg uses Office 2016

Office 2016

Novice

The original poster

Join Date: Aug 2016

Posts: 6

dh1sbg is on a distinguished road

Default

VBA: How to change color of a CommandButton

Hi there,

I want to change the command-button color from red to green using VBA

I defined a variable as a shape and used this code

myShape.Fill.ForeColor.RGB = RGB(0,255, 0)

Well, it does not work, no changes so far.

Any Idea, what I did wrong?

Regards

Bruno

Reply With Quote