Dear Xperts:
I am a school teacher creating an excel spreadsheet with radio buttons.
I have a cell,lets say D3, it has four radio buttons, and a linked cell D4, which gives the result of 1,2,3,4 based on which radio button pressed.
The radio buttons are grouped. They are contained in one cell and work properly.
My issue, is that when I copy them down, ie copy d3 to e3 and d4 an e4 etc. the cell link does not relatively change.
I can manually change the links in the properties, but I have too many to do.
I have researched this and have come to the conclusion that it can be done in VB or VBA.
Can someone help me with the code.
Sincerely
CJ
I am a school teacher creating an excel spreadsheet with radio buttons.
I have a cell,lets say D3, it has four radio buttons, and a linked cell D4, which gives the result of 1,2,3,4 based on which radio button pressed.
The radio buttons are grouped. They are contained in one cell and work properly.
My issue, is that when I copy them down, ie copy d3 to e3 and d4 an e4 etc. the cell link does not relatively change.
I can manually change the links in the properties, but I have too many to do.
I have researched this and have come to the conclusion that it can be done in VB or VBA.
Can someone help me with the code.
Sincerely
CJ
