Buttons in Excel

[William M]

I have created a questionnaire in groups of 4 questions with a potential score of 1 or 2, or 3, or 4. (numbers hidden).
I want people to select their answer using a radio button and to dump the appropriate answer (number) in a cell alongside.
Being new to macros and VBA I would appreciate help.
Not having done any programming (even in VBA) for >50 years I wonder if it is sensible to have a single script and to select which group of 4 questions (and hence the target cell for the result) by means of a counter to avoid massive duplication.
Many thanks. Bill

 

[Logit]

.
Not certain what you mean by "avoid massive duplication".

Here is a link (there are plenty on the Net) to a sample survey form. It should fit your needs.

http://blog.contextures.com/archives/2014/01/23/calculate-survey-scores-with-excel-option-buttons/

 

[William M]

As previously, many thanks!
Having set up what I was looking for, I have a follow-up question:
I used the procedure outlined in the video (which works perfectly) but there is always one button 'ticked': in essence, it is excellent for a binary answer such as English/French.
Is there some way I could start with all buttons unchecked? This would be ideal for what I'm looking for.