How to change color of a button and assign value to it in Excel VBA

Question

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: https://drive.google.com/file/d/11FvEGqGI2gd3PXTFiBQkORdXUKBnHbFh/view?usp=sharing

Thanks a lot in advance for your help.

https://drive.google.com/file/d/11FvEGqGI2gd3PXTFiBQkORdXUKBnHbFh/view?usp=sharing

Much appreciated.

Excel VBA에서 버튼의 색상을 변경하고 값을 할당하는 방법