ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Option Button - multiple selected (https://www.excelbanter.com/excel-worksheet-functions/83652-option-button-multiple-selected.html)

alanap

Option Button - multiple selected
 
I am trying to create a survey...80 questions with 3 options for each. So
next to the first question, I inserted 3 option buttons and then did the same
for each question after that. When you click on an option button anywhere,
it de-selects the option button you had selected before.

I need to make it to where one option button can be selected for each of the
80 questions.

Any help ASAP would be greatly appreciated!!!

Alana
281-584-0000

Dave Peterson

Option Button - multiple selected
 
If you use optionbuttons from the Forms toolbar, you can surround each group
with a groupbox.

If you use optionbuttons from the Control toolbox toolbar, you can change the
groupname of each optionbutton in that group to have the same groupname (under
properties).

You may want to look at a sample from Debra Dalgleish's site:
http://www.contextures.com/xlform01.html

alanap wrote:

I am trying to create a survey...80 questions with 3 options for each. So
next to the first question, I inserted 3 option buttons and then did the same
for each question after that. When you click on an option button anywhere,
it de-selects the option button you had selected before.

I need to make it to where one option button can be selected for each of the
80 questions.

Any help ASAP would be greatly appreciated!!!

Alana
281-584-0000


--

Dave Peterson


All times are GMT +1. The time now is 04:43 PM.

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