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

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).
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
 
Upvote 0
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
 
Upvote 0
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
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,217,383
Messages
6,136,254
Members
450,001
Latest member
KWeekley08

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
Back
Top