grouping Radio Buttons; Using ActiveX Controls
 

Hello experts! Im trying to enter radio buttons on a sheet (not UserForm)
and Im using ActiveX Controls (I dont want users moving the controls around
on the sheet so Im 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/qu...rouped_rbs.php
But I need to do it on a sheet and using ActiveX Controls.

Thanks!
Ryan---


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

grouping Radio Buttons; Using ActiveX Controls
 

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.

ryguy7272 wrote:

Hello experts! Im trying to enter radio buttons on a sheet (not UserForm)
and Im using ActiveX Controls (I dont want users moving the controls around
on the sheet so Im 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/qu...rouped_rbs.php
But I need to do it on a sheet and using ActiveX Controls.

Thanks!
Ryan---

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

--

Dave Peterson

grouping Radio Buttons; Using ActiveX Controls
 

Perfect! Thanks so much Dave!!!

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


"Dave Peterson" wrote:

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.

ryguy7272 wrote:

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/qu...rouped_rbs.php
But I need to do it on a sheet and using ActiveX Controls.

Thanks!
Ryan---

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

--

Dave Peterson
.