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

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

onlyadrafter

Well-known Member
Joined
Aug 19, 2003
Messages
5,703
Platform
  1. Windows
Hello,

Create a frame first, then put the option buttons in.
 

Harvey

Well-known Member
Joined
Nov 18, 2004
Messages
953
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.
 

Forum statistics

Threads
1,137,300
Messages
5,680,701
Members
419,928
Latest member
dolincasting

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
Top