Terrygordon
asked on
Assigning linked cells to Excel Form Controls
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.
Regards
Terry
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.
Regards
Terry
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks Norie. I created a VBA macro to create the radio buttons and assign names and links to them. Works fine.
Regards
Terry
Regards
Terry
ASKER
That might be a possibility. I will have a go at it tomorrow and get back to you. I suppose that once I delete the VBA, I could save it as a standard workbook.
Regards
Terry