Radio Buttons Question

[[email protected]]

Hello, Gurus.

In the attached TEST workbook I have several different sets of 5 radio buttons. I want to be able to make a selection in each set, but if I select a button in the first set it gets turned off when I make a selection in the 2nd set.

Any help would be greatly appreciated.

Thanks.

[6StringJazzer]

When you use Form controls in a worksheet, you must assign option buttons to Group boxes to determine which groups of option buttons act together.

First you will have to select each set of option buttons you have created, right click, and Ungroup them.
Then create a Group Box for each group.
Move the option buttons into the corresponding Group box
Move the group box back to where you want it on the page

There is a thorough explanation of how this works on this page

[dflak]

What you have to do is create a group box (the "XYZ" rectangle icon on the forms control on the developer tab). Radio buttons inside the group box interact with each other, but not with other radio buttons in other group box. Right now all your radio buttons are in a big group called "the sheet."

[Kinjo]

Hi - The way that I would do this is with Group Boxes

From the developer tab insert GroupBox and draw round the Option Buttons one by one creating several groups, one box for each question. This will limit the answer (selection) to only the Option Buttons within that box.

You will notice however, that this leaves a small outline around the groupbox, use the code below to remove the boxes.

Open VBA console (Alt+F11) then press Ctrl+ G to open the immediate options at the bottom, paste the below code in and press enter. Voila, the outline has gone.

Please Login or Register  to view this content.

Close the console

If you wanted to see the boxes again, replace false with true and press enter.

I have adjusted your file for you - attached.

[[email protected]]

Got it, Guys. Thanks for the help!

Have a good one.