Option buttons

  • Thread starter Thread starter Thrava
  • Start date Start date
T

Thrava

Folks,

I like to add a pair of three option buttons.
I like each set of 3 option buttons to be independent of
the other set so that if I select one of the option
buttons in the second set, it does not unselect any of the
previous buttons in previous set.

As it is, all six option buttons are linked in that I can
only select one of the six.

How can this be done?

Thanks
 
Thrava,

Put a separate frame control around each option pair. Make sure that the all
of the optionbox is within the frame to make it part of it.

When in frames, you can link each pair to a separate cell to test for
on/off.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Yes, sorry that is exactly what I mean.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Hi again Bob,
Done that, each set of 3 is fully contained within a
separate Group Box.
But again when I select an option control from a separate
group, it de-selects any selected option button from the
other group.

in other words, the two groups are not independent of one
another.
 
Hi Bob,
I've contained each of the two sets within its own group
box.
However, when I select an option box from set one (group
1), it still effects (un-selects) option boxes in the
other group (the other set contained in its own group box).
Do I need to do anything else after I draw a group box
around first 3 option boxes?
 
Are these optionbuttons taken from the forms toolbar or from the controltoolbox
toolbar?

If you used the optionbuttons from the Control toolbox toolbar, then you could
delete the groupbox (unless you want it there for esthetics). But right click
on each optionbutton within a "group" and select properties.

There's a GroupName property. Each group will have to have its own unique
name. (the default groupname is the worksheet name--so they're all grouped
together.)
 
Dave,
That's it.
Thanks sooo much
Thrava
-----Original Message-----
Are these optionbuttons taken from the forms toolbar or from the controltoolbox
toolbar?

If you used the optionbuttons from the Control toolbox toolbar, then you could
delete the groupbox (unless you want it there for esthetics). But right click
on each optionbutton within a "group" and select properties.

There's a GroupName property. Each group will have to have its own unique
name. (the default groupname is the worksheet name--so they're all grouped
together.)


--

Dave Peterson
(e-mail address removed)
.
Click to expand...
 
Isn't that typical, I normally assume that the OP is using controls from the
controltoolbox toolbar, and then get caught when its from the forms. When I
then go and assume it's from the forms toolbar, it's controltoolbox.

Life is tough<vbg>

Bob
 
Back
Top