D
debbie.vega
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!
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!