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

  • 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 was chosen?


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


    Attachment is the mock-up for your reference:


    Thanks a lot in advance for your help.


    Much appreciated.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!