Forms Toolbar, "Choice" button(s).

Cerestes

Board Regular
Joined
Jan 31, 2004
Messages
185
Evening,

Have a fill with 3 seperate "YES/NO" questions.

Was able to use the forms toolbar and the 'choice' (circular) buttons for the first question.

Unfortunately, when I add the buttons for the second (and third) questions, it seems to be all part of the SAME button sequence so I can only select one of the six buttons.

Anyone able to offer a quick tutorial as to how to get these seen by excel as seperate 'options'?

Thanks!
 

Some videos you may like

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

parry

MrExcel MVP
Joined
Aug 20, 2002
Messages
3,355
Hi, the round buttons are called Option Buttons. The intention of these types of controls is to enable you to pick one option out of several available options.

To get option buttons grouped so other choices arent mixed in then draw a Group Box. For example you might have a question which requires Yes or No. You would draw a group box then inside the box draw 2 option buttons - one Yes and one No. You might have another question asking which direction you want to go. Again you would draw a group box then inside create 4 options buttons labelled Up, Down , Right and Left.

If your wanting to choose one or more options then use CheckBoxes instead.
 

Watch MrExcel Video

Forum statistics

Threads
1,127,356
Messages
5,624,219
Members
416,017
Latest member
moritz210

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