Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I'm trying to create a questionnaire where there are 3 possible responses to
each question, each wtih a different value, but where the respondants can only give one answer per question. I've set it up using the checkboxes from a formula toolbar at this point. Would anyone be able to explain to me in layman terms how to somehow group the boxes such that only 1 out of 3 can be checked at a time (any second box checked automatically clears the first) ? As well, is there any way to have a function (or other?) at the end that verifies if all questions have been answered and/or to tell the person which ones are remaining? Thanks in advance for any help that people can offer... Cheers, Andi |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Use RadioButtons instead.
They are automatically mutually exclusive HTH -- AP "Andi" a écrit dans le message de news: ... I'm trying to create a questionnaire where there are 3 possible responses to each question, each wtih a different value, but where the respondants can only give one answer per question. I've set it up using the checkboxes from a formula toolbar at this point. Would anyone be able to explain to me in layman terms how to somehow group the boxes such that only 1 out of 3 can be checked at a time (any second box checked automatically clears the first) ? As well, is there any way to have a function (or other?) at the end that verifies if all questions have been answered and/or to tell the person which ones are remaining? Thanks in advance for any help that people can offer... Cheers, Andi |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Open Excel 2003 from Windows Explorer | Excel Discussion (Misc queries) | |||
convert pocket excel back to standard excel | Excel Discussion (Misc queries) | |||
where can I find a excel based questionnaire template? | Excel Discussion (Misc queries) | |||
VBA for Excel 2000 file is corrupt | Excel Discussion (Misc queries) | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |