Mutually exclusive check boxes

**gazzz_tha1** · 03-28-2012, 09:08 PM

Hello,

I'm trying to create mutually exclusive check boxes and after some searching, have found a macro that allows me to do so. I've attached a spreadsheet that has the functioning macro in it, however there is 1 small problem. When I select 'Yes' in the attached sheet, it deselects the 'CheckBox1' option. Once I've selected either Yes, No or Unsure, I can go back and select 'CheckBox1' again and this time it will save both options.

What I want to be able to do is select either 'CheckBox1' or/and 'Checkbox2' (so these 2 options are not mutually exclusive). Then I want to also be able to select either 'Yes', 'No' or 'Unsure' without it unselecting the previous selections (i.e. these 3 options are mutually exclusive of eachother, and are exclusive of the first 2 options).

Can anyone help with what I'm sure is a real simple fix to the code I'm using?

Thanks very much
Gareth

*Edit - server won't let me attach the excel file, so I've attached a screen dump of my example, and code is below:

Please Login or Register  to view this content.

**Dennis7849** · 03-28-2012, 09:20 PM

This can be done but it is NOT considered good practice to do. This functionality is designed into radio button controls.

**gazzz_tha1** · 03-28-2012, 09:44 PM

Thanks Dennis7849 - but that doesn't really help my situation..

**Dennis7849** · 03-28-2012, 11:35 PM

If you use Radio buttons, you do not have to write extra code to get the same functionality.

But if you must use checkboxes, then you will have to do this;

In each checkbox_Change event, you must check the value to be checked(True). If it is True(Checked) then you must uncheck all other checkboxes. This is horribly inefficient to it this way.

**gazzz_tha1** · 03-29-2012, 12:33 AM

Hi Dennis,

I understand the difference between radio buttons and check boxes, and I understand what their intended uses are. I'm not interested in using radio buttons for this application. I'm not sure if you looked at my original code, but I've managed to get check boxes mutually exclusive, albeit with a slight problem.

What I want to be able to do is select either 'CheckBox1' or/and 'Checkbox2' (so these 2 options are not mutually exclusive). Then I want to also be able to select either 'Yes', 'No' or 'Unsure' without it unselecting the previous selections (i.e. these 3 options are mutually exclusive of eachother, and are exclusive of the first 2 options).

In easy terms - think of it as:
Q1 - Please tell me about yourself?
- Male.
- Under 30 years old.

Q2 - Do you like chicken?
- Yes.
- No.
- Unsure.

Currently, answering Q1 is fine, but the moment you answer Q2 it erases the responses from Q1. If you answer Q2 first, then answer Q1 - it works fine and we have a mutually exclusive response selection for Q2, and an answer for Q1...