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("Option Button 1001").Select
With Selection
.Value = xlOff
.LinkedCell = "$K$142"
.Display3DShading = True
End With


But 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!