ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Option Button in form controls (https://www.excelbanter.com/excel-programming/441441-option-button-form-controls.html)

Pnoahjones

Option Button in form controls
 
How do i have group the option buttons so i can have two seperate entities?

Bob Phillips[_4_]

Option Button in form controls
 
You can either put them frames, or set the GroupName property.

--

HTH

Bob

"Pnoahjones" wrote in message
...
How do i have group the option buttons so i can have two seperate
entities?




Mike H

Option Button in form controls
 
Hi,

By default when you put an option button on the sheet it belongs to the
'worksheet' group. Put a group box on the sheet and put options buttons in
that and they will belong to that group and act independently of the
worksheet group. You can have more than 1 group box.
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Pnoahjones" wrote:

How do i have group the option buttons so i can have two seperate entities?


Dave Peterson

Option Button in form 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.

Pnoahjones wrote:

How do i have group the option buttons so i can have two seperate entities?


--

Dave Peterson


All times are GMT +1. The time now is 01:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com