I am creating a spreadsheet to evaluate software.
I have over 50 questions that I want to evaluate for each.
I have created a couple of Group Boxes with 5 radio buttons in each. The radio buttons are labeled from Poor to Excellent. For example, if "Poor" is selected, then the Cell link value is 1. If "Excellent" is selected then the Cell link value is 5, etc.
It is tedious to create each box and radio buttons one at a time.
Is there a way to copy/paste an existing Group Box with buttons and then change the Cell link to a different cell?
I have tried searching, but the AI robots do not turn up any good links.
I figured it out for myself!
I selected the Group Box. Holding the control key, I then selected each button. Then I did copy/paste. (Ctrl-V)
I can paste multiple times.
I then edited the format control for the first box to reference a different cell.
Glad you found a solution, David. Please let us know if we can help in the future.
