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

--

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" wrote:

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

--

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 wrote:

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

--


--

Dave Peterson

That's it. Thank you.

--

"Tony" wrote in message
...
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" wrote:

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

--

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

--

"Dave Peterson" wrote in message
...
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 wrote:

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

--


--

Dave Peterson

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)

On Mon, 19 Jan 2009 13:26:57 -0500, "PCLIVE"
wrote:

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