option button grouping

[Guest]

I know how to use option buttons and group the option buttons in a group box.
I have a worksheet in which I the option button groups are separated from
each other. Example (the numbers represent the option button group):

Row 1: 1 1 1 1
Row 2: 2 2 2 2
Row 3: 1 1 1 1
Row 4: 2 2 2 2

If I overlap the group boxes than the option buttons do not stay separated.
If I create 4 groups then Row 1 will not deselect when Row 3 is selected.
Help!

I'm using 2002 Excel.

 

[Guest]

Hold down CTL and click each option button in the first row, then go to
properties and in the group name box give them a name, do the same thing to
the ones in row 3 giving them the SAME group name. Select all in row 2 and
give them a seperate group name, and finally give group 4 a group name the
same as you did for row 2. Thats a mouthfull.

 

[Guest]

When I select all of the buttons in a row a go to the properties there is no
place to assign a group name. Could you explain this further?

 

[Guest]

Hmm, must be something different between 2002 and 2003. See if there is
anything in the properties when you select multiple values that says the
sheet name. That or I think i remember you might be able to give each in the
group the same name one at a time. Sorry not a 100% sure though.

 

[Guest]

From a post elsewhere, try this

If your talking about using a control array, which what your code shows, you
do that by creating a single checkbox. Naming it and setting it's index
property to 0. Then cut and paste it. You'll see the name remains the same
but the index changes. Note that you can change most properties of the
checkboxes, like the caption, but just not the name property if you want to
keep them in an array. Is this what you were asking?

 

[Dave Peterson]

If you used optionbuttons from the Forms toolbar, put a groupbox (also on that
same toolbar) around the optionbuttons.

If you used optionbuttons from the control toolbox toolbar, rightclick on each
of the members of the group, choose properties, and give that group a unique
groupname.

 

[Guest]

No. The difference is that I'm using the forms buttons, not the control
buttons. I was able to do what you're describing with the control buttons.
I'll try to use the control buttons, although I'm not impressed with the look
of them. If anyone else knows anything about forms buttons then let me know.