Change the Color of One Command Button with Click of Another

Hi All,

Say I have 3 command buttons on a sheet (in real life I have 84). I created a class module which uses one simple sub, executing a command based on which button is clicked. Subsequently, the clicked button changes color. If you click another button, that button changes color. My challenge: when the second button is clicked, I want the first button to resume its original color.

For Simplicity's sake, I created a workbook with 3 command buttons and applied only the code needed to change the color. Please check out the code below, and the attached workbook and see if you can come up with a solution to my challenge.

General Module:

Please Login or Register  to view this content.

Class Module:

Please Login or Register  to view this content.

Thanks!

The Buttons are grouped in the Class_Init. so when the code in the Class Module is executed, it only sees the clicked button.

As it is, if you click a button once, it changes to red. Click it again and it goes back to gray. The problem is that you can click button 1 and make it red, and click button 2 and make it red at the same time. I'd like to make it so that if you click button two, only button 2 will be red... all others will be gray.

Is it possible with a class module, to work on "unclicked" buttons?

Thanks!

I get a type mismatch in the For

Off to a meeting... Might be a while before I check Back... Thanks for working on it though!!

Hi Norie...

I get a number of errors trying to do this. Perhaps the difficulty is in how I declare Buttons3?? Did it actually work for you when you put the code in the sample workbook I attached? (Assuming of course you did). If so, What did you declare Buttons3 as. I have tried everything that I think makes sense...

Any assistance is greatly appreciated.

Ray

Ha! Okay... I used the same method used in the General Module to create the Class Module - Inside the Class Module... Works like a charm. See the code below for giggles

General Module:

Please Login or Register  to view this content.

Class Module:

Please Login or Register  to view this content.

So this one is solved... Thanks for the help!

Awesome!... I'm going to go back to your original and play with it... I am a newb, and didn't think to declare it as Public.

Thank You again