Hi - I have a spreadsheet based questionnaire, where I can't use activeX controls or VBA because of the client's security protocols. To get round the problem I am using form control radio buttons. These will be grouped in pairs (Yes and No) against 80 questions. Each pair has a different linked cell and enters a 1 or a 2 in this cell.
Is there a quick way to assign the linked cell to each radio button, without having to assign a cell to each pair and then group them (80 times!!!). I did start this and then accidentally copied some data into the range containing the linked cells. Excel then basically reassigned the same linked cell to all the radio buttons and does not give me the option to undo.
Surely, there must be an easier way to do this?
Alternatively, is there a way to do this with form control checkboxes, grouped in pairs, so that if one is checked, the other is automatically unchecked.