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 mockup for your reference:

Thanks a lot in advance for your help.

Much appreciated.