ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Grouping radio option buttons (https://www.excelbanter.com/excel-programming/360267-grouping-radio-option-buttons.html)

ahmed

Grouping radio option buttons
 
I have a questionnaire that contains 5 responses for each question; Never,
Rarely, Sometimes, Usually, Always, and N/A. I would like to collect a value
if the response is rarely, sometimes, usually, always but not for never or
n/a. I have tried to place the 3 that I want to collect data for within a
group box and the other 2 outside, but this will allow for to buttons to be
selected at the same time. does anybody have any suggestions?

Bob Phillips[_6_]

Grouping radio option buttons
 
If you group them together and link them all to the same cell, you will get
a number 1 to 5 in that cell. You could then count any 1,2 or 3 value and
ignore 4 or 5.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"ahmed" wrote in message
...
I have a questionnaire that contains 5 responses for each question; Never,
Rarely, Sometimes, Usually, Always, and N/A. I would like to collect a

value
if the response is rarely, sometimes, usually, always but not for never or
n/a. I have tried to place the 3 that I want to collect data for within a
group box and the other 2 outside, but this will allow for to buttons to

be
selected at the same time. does anybody have any suggestions?





All times are GMT +1. The time now is 07:27 AM.

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