OptionButtons from ControlToolbox

[PCLIVE]

Ok this time my question is with OptionButtons. When I create them, they
seem to all link to one another. How can I have several groups of option
buttons where the individual groups work independently? So when I click an
option button in group 2, I would prefer that it did not affect the selected
option button in group 1.

Thanks,
Paul

--

 

[Tony]

I know in the properites section there is a field called "GroupName" and if
you give all the optionbuttons you want linked together the same GroupName
they will work together and not affect other optionbuttons in other groups.

 

[Dave Peterson]

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

 

[PCLIVE]

That's it. Thank you.

--

I know in the properites section there is a field called "GroupName" and if
you give all the optionbuttons you want linked together the same GroupName
they will work together and not affect other optionbuttons in other
groups.

 

[PCLIVE]

Thanks Dave. I was using the OptionButtons from the Control Toolbox.
You're suggestion is what I was looking for.

--

 

[Chip Pearson]

Create multiple Frame controls and put the related sets of options
buttons within the Frame. Mutual exclusivity is applied only to the
controls within the same Frame.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)