How to count score using option button in userform

Hi, i am trying to make a Score Sheet Form using option button.
Can anyone Hint/Help Me. how to assign number to these buttons. and all option must be picked.

Thanks

I have attached a solution that I gave in the past, you may be able to see how this scores.
It is an 'elastic' - self expanding 'Likert' type questionnaire - to expand simply insert another block (10) additional questions into Sheet1.
If your UserForm is of fixed format I will look at that later today and try to give a response.

As promised looked at your specific sheet.
The solution provided uses the 'group' condition to separate the 'option button' and uses the 'tag' condition to assign a value to the relative option buttons.
To intercept the 'click' event of the 'option buttons' I have created a 'Class Module' which fires each time an 'Option Button' is clicked and calculation is then done 'on the fly'.

glad to have helped - thanks for the feedback and the added rep point.
Excel is like opening 'Pandora's box' - full of interesting ideas.