How do I limit the number of selected check boxes in a list to only having one check box selected in an Excel spreadsheet?
Home > IT Answers > Microsoft Windows > How do I limit the number of selected check b...
2knowmore
5 pts.
0
Q:
How do I limit the number of selected check boxes in a list to only having one check box selected in an Excel spreadsheet?
Microsoft Excel, Excel Forms
I am recreating a transfer form we currently have on paper into an Excel spreadsheet to have it electronically emailed. In the form I have a section that asks the user to choose a desired station to transfer to from a list of 3 stations with check boxes next to each station. I would like to have it to where the user can only check one box at a time. In other words if the user would like to select two stations, when the user selects a second box from the list to click the first box the user clicked would be unchecked leaving only one checked check box in the list. Thank you in advance for your help.

Software/Hardware used:
Excel 2007
ASKED: Nov 7 2009  4:36 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Chatmaker
670 pts.
0
A:
 RATE THIS ANSWER
+1
Click to Vote:
  •   1
  •  0
  • AddThis Social Bookmark Button
I hope I understand your problem. If so, instead of using check boxes, use radio buttons. That is their natural function to limit responses to only one selection. If "No Station" is valid (no boxes checked), then add a "No Station" radio button.
Last Answered: Nov 8 2009  4:28 AM GMT by Chatmaker   670 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0