grouping Radio Buttons; Using ActiveX Controls

  • Thread starter Thread starter ryguy7272
  • Start date Start date
R

ryguy7272

Hello experts! I’m trying to enter radio buttons on a sheet (not UserForm)
and I’m using ActiveX Controls (I don’t want users moving the controls around
on the sheet so I’m trying to make the objects locked). Now, I seem to be
stuck as to how to get my 6 radio buttons into 3 groups, so that I can choose
three buttons. Right now, it is only letting me choose one button!

Basically, this is an example of what I want to do:
http://www.techonthenet.com/excel/questions/grouped_rbs.php
But I need to do it on a sheet and using ActiveX Controls.

Thanks!
Ryan---
 
Saved from a previous post:

If your optionbuttons are from the Forms toolbar, the put all your optionbuttons
in each group in a groupbox (also on that Forms toolbar).

If your optionbuttons are from the Control Toolbox toolbar, then rightclick on
each optionbutton show the properties (you'll have to be in design mode for
this). Each group should have its own unique groupname.
 
Perfect! Thanks so much Dave!!!

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


Dave Peterson said:
Saved from a previous post:

If your optionbuttons are from the Forms toolbar, the put all your optionbuttons
in each group in a groupbox (also on that Forms toolbar).

If your optionbuttons are from the Control Toolbox toolbar, then rightclick on
each optionbutton show the properties (you'll have to be in design mode for
this). Each group should have its own unique groupname.
Click to expand...
 
Back
Top