Thread: Radio Buttons

I'm trying to create a form using radio buttons from the "Forms Tool Bar" and not sure I shouldn't be using the "Control Tool Bar"

I've got multiple buttons and wanted to group them so i used the "Group Box" from the Forms tool bar but now there's a box around the buttons (I've turned off Printing for the box) that gets in the way of other text on sheet. I did some searching and thought I read where you could also use the drawing tool bar and draw a rectangle around the buttons which would then let them operate independent of other groups of buttons but that doesn't seem to work so I'm guessing I imagined it. I also noticed that if you don't draw the "Group Box" around the hole radio button box, they don't work with others in the same "Group Box"

I'm not sure if I should use the buttons in the "Control Tool Bar" but I'm thinking I should so that I have the flexibility should I decide to do something different in the future. I'm thinking about using the buttons to hide a sheet as well as select the sheet for printing, but for now one hurdle at a time.

Lastly I tried looking up some information on how to get the "Control Tool Bar" radio button to behave similar to the "Forms" version of the button (i.e. click the button and it appears to alternate from other buttons in the group), however when I place my mouse over the button it selects it rather than letting me change it's state from true to false.

What am i doing wrong?

JeanRage,
This doesn't do what I want it to. If I've got 4 radio buttons, and want to put them in groups of 2 so that buttons 1 and 2 work together and 3 and 4 to work together. At the same time, I don't what actions on buttons 1 and 2 to have an effect on 3 and 4.

JeanRage,
thanks for the spreadsheet, but I was trying to avoid using the "Group Box" because you can't change the line colors to White and it covers up some of the text on the form. I can delete the words "Group Box 1", "Group Box 2", but that doesn't make the black line around the box disappear.

I'd use the "Control Tool Box" but I can't figure out how to make it selectable to the user when they're selecting the buttons while on line.

Here's something I'd like to do, Group 1 is to make sheet 1 Hide, and Group 2 would make sheet 2 hide.

Here's a spreadsheet to kind of explain

you can hide all the forms groupboxes like this

Code:

Sub HIDE()
ActiveSheet.GroupBoxes.Visible = False
End Sub

Martindwilson,
I was thinking I'd have to add the code info you provided in a Auto_Open function, thinking that I'd have to execute it each time the spreadsheet loaded. When I opened and closed the spreadsheet, the groupbox remained hidden and i had to set it to TRUE in order to get it to reappear.

Is this a global setting?