Forms: Group Boxes and Option Buttons

[Kathryn]

I created a group box of 5 option buttons and linked them
to a specific cell with an absolute reference. I then
created another group box with 5 additional option buttons
and linked them to a different cell with a different
absolute reference. When I did this, all the links in the
option buttons from the first group changed to the second
group's links. Excel seems not to be recognizing the group
boxes and is grouping ALL the option buttons into one
group.

Any suggestions? What isn't working here?

Thank you!
Kathryn

 

[Jake Marx]

Hi Kathryn,

You should use the GroupName property of the OptionButtons to specify which
"group" of option buttons each belongs to. So for your first 5, set the
GroupName property of each to something like "optgrp1", and for the second
5, set the GroupName property of each to "optgrp2". Now Excel should know
to treat them as separate groups of option buttons.

--
Regards,

Jake Marx
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]

 

[Dave Peterson]

Did you use the option buttons from the Forms toolbar or from the control
toolbox toolbar?

If from the control toolbox toolbar, then follow Jake's advice, but if they're
from the Forms toolbar, make sure that they're completely in the groupbox.