Using 'Option Buttons'

[Guest]

I'm trying to make a table that has 4 rows of 3 option buttons within it.
The tricky part is that I want each row of option buttons to act
independently of the other rows.

I can't seem to be able to find a way to do this, because no matter what
cell I link any of the buttons to they all just follow suit, so i end up with
12 buttons linked to one cell every time.

I'm using MS Excel 2003 if that makes a difference. Thanks in advance for
any help anyone can provide.

 

[Jim Rech]

If you're using option buttons from the Forms toolbar put a group box around
the ones your want to operate together. You can make the group boxes hidden
and this will still work. The option buttons must be entirely inside the
group box.

If you're using option buttons from the Control Toolbox just give the ones
in sync the same Groupname (in their Properties).

--
Jim
| I'm trying to make a table that has 4 rows of 3 option buttons within it.
| The tricky part is that I want each row of option buttons to act
| independently of the other rows.
|
| I can't seem to be able to find a way to do this, because no matter what
| cell I link any of the buttons to they all just follow suit, so i end up
with
| 12 buttons linked to one cell every time.
|
| I'm using MS Excel 2003 if that makes a difference. Thanks in advance for
| any help anyone can provide.

 

[Guest]

How would I go about hiding these group boxes?

 

[Jim Rech]

They is no way through the UI to do this so you must use a macro. This
hides all of them on the active worksheet:

Sub HideGBs()
Activesheet.Groupboxes.Visible = False
End Sub

--
Jim
| How would I go about hiding these group boxes?
|
| "Jim Rech" wrote:
|
| > If you're using option buttons from the Forms toolbar put a group box
around
| > the ones your want to operate together. You can make the group boxes
hidden
| > and this will still work. The option buttons must be entirely inside
the
| > group box.
| >
| > If you're using option buttons from the Control Toolbox just give the
ones
| > in sync the same Groupname (in their Properties).
| >
| > --
| > Jim
| > | > | I'm trying to make a table that has 4 rows of 3 option buttons within
it.
| > | The tricky part is that I want each row of option buttons to act
| > | independently of the other rows.
| > |
| > | I can't seem to be able to find a way to do this, because no matter
what
| > | cell I link any of the buttons to they all just follow suit, so i end
up
| > with
| > | 12 buttons linked to one cell every time.
| > |
| > | I'm using MS Excel 2003 if that makes a difference. Thanks in advance
for
| > | any help anyone can provide.
| >
| >
| >