How to change the color of a button and assign value to it when choosing, and in parallel the other buttons will change to the same color in Excel VBA

[joevn93]

I have 5 criteria. Each criteria has 5 different buttons (different color) represent for each option with a certain score for each.

How to remain the color of a desired button and assign value to it when choosing, and in parallel the other buttons will change to the same color (grey for instance)? And at the same time, the comment cell will appear the describe text for the option that I chose

After choosing the option for all criteria, we will have the overall score below

Here is the mock-up for your reference:

Thanks a lot in advance for your help.

Much appreciated.

 

[JulioTheLess]

Does conditional formatting meets the job?

 

[joevn93]

It's required to use macro VBA in this case @JulioTheLess

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: How to change color of a button and assign value to it in Excel VBA
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.