Excel Check Boxes per Question

anthonyr

New Member
Joined
Sep 6, 2006
Messages
3
I have several questions and each one has a few options as answers.

I am trying to have check boxes for each option the user can click on in answering each question.

I created the check boxes and all are linked to a different tab where the True or False response appears when you click.

The problem is that I cannot figure out how to make the clicking be an option for one question at a time...For example, when I click an option for Q1 the click mark on Q2's option disappears etc etc...I want to be able to select a click/check box one question at a time...

Does this above make sense...Any insights?

Thanks
 

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.
I hope you are using the ActiveX components and not the Forms toolbar.

- Rightclick on the radiobutton
- Click properties

Now a window appears, with a list of attributes.
One of the is Group Name.
Change the Group Name of a set of radiobuttons in order to separate them from the rest.

The end result will look something like this:

Group1:
Radio1
Radio2

Group2:
Radio3
Radio4

etc.

Hope this helps.
 
Upvote 0

Forum statistics

Threads
1,217,317
Messages
6,135,847
Members
449,965
Latest member
Ckl43

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