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

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.
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,214,643
Messages
6,120,702
Members
448,980
Latest member
CarlosWin

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