OPTION bUTTONS

NatalieM1982

New Member
Joined
Jul 27, 2006
Messages
43
Hi


ive created several option buttons.


How can i create it so that when i select one option it will also select another option at the same time? Please see eg below so for eg lets say i pick female and then i wanted to pick Australia as my answer how do you select both?

for eg i have one list with

are you male or female? pls select

male
female

Where are you from?

Australia
USA
Europe
Other


Thanks a Million

Natalie
 

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.

Smitty

Legend
Joined
May 15, 2003
Messages
29,536
If you're talking about Forms Controls, then you can put each group of OB's in a Group Box.

Or are you dealing with ActiveX or User Form controls?

HTH,

Smitty
 

NatalieM1982

New Member
Joined
Jul 27, 2006
Messages
43
OPTION BUTTONS

YEST IM TALKING ABOUT FORM WHEN YOU SELECT ONE FOR EG FEMALE THEN YOU SELET FRO EG usa- THE OB for female gets unselected and then select OB for USA- i WANT IT SO THAT whoops caps sorry,

i want it so that when you select ob for lets say female it selects it and then when you select OB for USA its selects it as well so your result is that you now have two option buttons selected ie female and USA


thanks
 

NatalieM1982

New Member
Joined
Jul 27, 2006
Messages
43
If you're talking about Forms Controls, then you can put each group of OB's in a Group Box.

Or are you dealing with ActiveX or User Form controls?

HTH,

Smitty


WHATS A GROUP BOX???


Thanks
 

Smitty

Legend
Joined
May 15, 2003
Messages
29,536
In the Forms toolbar, there's an option for a Group Box, which allows you to group a series of controls together.

You just grab the OB's you want to be grouped into the Group Box.

If that doesn't make sense PM me and I'll send you an example.

Smitty
 

Forum statistics

Threads
1,148,342
Messages
5,746,192
Members
423,997
Latest member
eakenila

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top