How do I limit the number of selected check boxes in a list to only having one check box selected in an Excel spreadsheet?

5 pts.
Tags:
Excel Forms
Microsoft Excel
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following