Macro for unchecking checkboxes

**Steve Strackbein** · 07-29-2010, 11:43 AM

Hi all-

I have created a survey using the control toolbox within Excel. In this survey I have several questions that have several checkboxes available for answer selection. I want to add a macro so that if a particular box is checked then all of the other boxes are unchecked. Here is an example:

Question:
What type of grass is on your lawn?
CheckBox 1 = Bent
CheckBox2 = Bermuda
CheckBox 3 = None

I want the user to be able to click on one or both of checkboxes 1 or 2, but when check box 3 is selected it verifies that neither checkbox 1 or 2 is selected. Any thoughts will help.

Thanks,
Steve

**JBeaucaire** · 07-29-2010, 11:45 AM

You're using the wrong control. You want to use Radio Buttons instead of checkboxes.

One of the controls in the Radio Buttons allows you to group sets of radio buttons together. Once grouped, only one button in the group can be selected.

**JBeaucaire** · 07-29-2010, 11:46 AM

EDIT: Sorry, just noticed your last comment about multiple selections. Yes, that would require fancy coding, coding you would have to maintain.

I suggest you STILL convert to radio buttons and add a 4th option.

[ ] Option 1
[ ] Option 2
[ ] Option 1 & 2 <-----added
[ ] Option 3