OptionButtons from ControlToolbox

P

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

--
 
T

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.
 
D

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.
 
P

PCLIVE

That's it. Thank you.

--

Tony said:
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.
 
P

PCLIVE

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

--
 
C

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top