Prev: Time in Seconds Only
Next: Code to add gridlines to Excel Pivot Tables
From: ryguy7272 on 6 May 2010 11:20
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---


--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.
From: Dave Peterson on 6 May 2010 11:54
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/questions/grouped_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
From: ryguy7272 on 6 May 2010 13:01
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/questions/grouped_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
> .
>
 | 
Pages: 1
Prev: Time in Seconds Only
Next: Code to add gridlines to Excel Pivot Tables