Option (Radio) Buttons in Excel 07

[skpowers]

I have inserted several radio buttons into an Excel 07 spreadsheet, but when I try to link one button to a cell, the cell link for all of the buttons change to that cell. I would like to have different groups of radio buttons linked to different cells.

Any advice?

Thanks

 

[CWatts]

You'll need to use Group Boxes to determine which radio buttons belong with one group, and which ones belong to another group.

You'll then have annoying group boxes on your scrreen, and you can use the following macros to hide and show them.

Sub GB_Hide()
Dim sh As Worksheet
Dim gBox As GroupBox
Set sh = ActiveSheet
 
For Each gBox In sh.GroupBoxes
    gBox.Visible = False
Next gBox
 
End Sub
 
 
Sub GB_Show()
Dim sh As Worksheet
Dim gBox As GroupBox
Set sh = ActiveSheet
 
For Each gBox In sh.GroupBoxes
    gBox.Visible = True
Next gBox
 
End Sub

 

[skpowers]

This worked perfectly. Thank you.