User form Change button color

[meabrams]

Im looking for a simple way to just change background color of a userform from the button being clicked it would change the color from gray to green when clicked, then when clicked again back to gray....
there are a bunch of button and I was hoping not to have to code them all.

Thank you for your help

[walruseggman]

Please Login or Register  to view this content.

[Raymundus]

Hi there,

I'm not sure what your Buttons do, but you can't change the color of a Form Control Button. You can however change the color of an ActiveX control Button. And if you don't want to code for each button, you will have to use a Class Module.

Step One is to get rid of your Buttons and Replace them with CommandButtons. Then Insert a Class Module. Name the Class Module Buttons3 and paste the code below into the Class Module.

Please Login or Register  to view this content.

Then in a General Module, Paste This Code:

Please Login or Register  to view this content.

Run Class_Init and click your CommandButtons.

You can Call Class_Init from Workbook_Open if you'd like.

As a note, I didn't see what your buttons do as I'd mentioned above, but their function should be carried out in the Class Module.

Additionally, in the interest of honesty, I found the basis of this code on this forum some time ago, and for the life of me, I can't find it again to give credit to the author... But it works great!

Thanks!