Share via

Dependant Checkboxes in excel

Anonymous
2011-07-19T22:30:27+00:00

Does excel have the checkboxes/radio buttons that can be used which are dependant on each other?  ie- if is select one checkbox or radio button, I can not select another.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

HansV 462.6K Reputation points
2011-07-19T23:16:17+00:00

You must use option buttons (a.k.a. radio buttons).

If you use Form Controls, you can divide them into groups by creating group boxes (also form Form Controls) and placing option buttons within a group box.

If you set the cell link for one option button in a group box, you automatically set it for the other option buttons in the same group box.

If you use ActiveX controls, you can divide them into groups by setting the GroupName property in the Properties window (right-click an option button while in Design Mode and select Properties from the context menu). Option buttons with the same GroupName are related - only one can be "on". Don't forget to turn off Design Mode when you want to use the buttons.

Was this answer helpful?

4 people found this answer helpful.
0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more