software

I got the most tedious task of creating a questionare on an excel
sheet using option buttons. There are 3 buttons per group box and 100
questions for each person to fill it in.(50 people)

I will have to reference one option button to a cell for each question.
After doing a few my hurt already hurts and there are about 3000 more
to do. I tried recording a macro:

ActiveSheet.Shapes(quot;Option Button 1001quot;).Select
With Selection
.Value = xlOff
.LinkedCell = quot;$K$142quot;
.Display3DShading = True
End WithBut don't know how to make it for all of them automatically. i am new
to VBA and the only programming i have done is in Matlab.

I want something like

For each option button (1 n) (since they are in sets of three n=3)
Link cell K14 m (this one does move one by one so m=1)

Oh dear if there is a solution i would be so grateful. Anything to
avoid RSS

Thank you!