Hi,
I am creating a feedback survey with 10 questions which is based on option buttons.
But I’m not in love with standard excel option buttons because I can’t really do a whole lot of formatting on them; can’t change their size/colour and basically they just look old and ugly.
I decided to use my own shapes instead. In the following image, I’ve replaced the option buttons with shapes and have assigned a macro to each of them.
buttons.PNG
I have used the following code which allows me to assign value based on highlighted image.
Here is how it looks:Please Login or Register to view this content.
buttons2.PNG
I have the following issue:
1) I don't know how to execute this macro multiple times for several questions on one sheet, i.e. have 10 questions where the user could select option 1-5 for each question.
2) Once the above is working, is there a neat way to calculate average score for the 10 questions?
I would greatly appreciate any help I can get! I have attached the xls.
Best Regards
Jiri
Bookmarks