ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   OptionButtons from ControlToolbox (https://www.excelbanter.com/excel-programming/422670-optionbuttons-controltoolbox.html)

PCLIVE

OptionButtons from ControlToolbox
 
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

OptionButtons from ControlToolbox
 
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

--





Dave Peterson

OptionButtons from ControlToolbox
 
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

PCLIVE

OptionButtons from ControlToolbox
 
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

--







PCLIVE

OptionButtons from ControlToolbox
 
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




Chip Pearson

OptionButtons from ControlToolbox
 
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



All times are GMT +1. The time now is 05:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com