Hi all,
I'm creating a spreadsheet where one sheet is the input worksheet.
On the input worksheet I am creating multiple sets of radial buttons using Form Control.
Challenges:
- Form Control: The first set of 5 radial buttons would interfere with the second set of 3 radial button. I tried to specify the "linked cell" but they don't work. The second set of "linked cell" will overwrite the linked cell in the 1st set of buttons.
- Active X: I have been playing around with the radial buttons using active x in the last hour, looking at the "Properties" but I still can't figure out how to create multiple sets of radial buttons.
I think I'll need about 4-5 sets of radial buttons on the same worksheet.
Please kindly advise. Thank you very much.
I'm creating a spreadsheet where one sheet is the input worksheet.
On the input worksheet I am creating multiple sets of radial buttons using Form Control.
Challenges:
- Form Control: The first set of 5 radial buttons would interfere with the second set of 3 radial button. I tried to specify the "linked cell" but they don't work. The second set of "linked cell" will overwrite the linked cell in the 1st set of buttons.
- Active X: I have been playing around with the radial buttons using active x in the last hour, looking at the "Properties" but I still can't figure out how to create multiple sets of radial buttons.
I think I'll need about 4-5 sets of radial buttons on the same worksheet.
Please kindly advise. Thank you very much.