Radio Buttons linking to different cells

steveshort

New Member
Joined
Jul 25, 2014
Messages
2
Hi all

Hoping someone out there can help with something that is probably very simple... but is driving me insane!

I've created a survey with 5 "multiple choice" options for each question. I want to use a radio button to selcet one answer for each question. I have linked the five buttons to a cell, so when a button is clicked, it inserts the value for that button in the linked cell. So far so good!

I want the same to apply to every question, but when I create a second set of five buttons (for the next question), they still link to the same cell as the first set. I have tried changing the link cell, but when I change it, all the buttons (for the previous questions too) link to the new cell.

How can I separate the cell link for each set of five buttons?

Many thanks, in anticipation... :)
 

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.
Are these all within the same option group? If so you need to create 2 option groups.
 
Upvote 0
Are these all within the same option group? If so you need to create 2 option groups.

Thanks for your reply. I thought I had created two groups, but after your message I repeated it and found I had done it wrong - now it's worked :)

Thanks,
Steve
 
Upvote 0

Forum statistics

Threads
1,223,164
Messages
6,170,444
Members
452,326
Latest member
johnshaji

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top