VBA to Enable Form Control Check Boxes Based on Value of Another Cell

I have some check boxes in which depending on the value on of cell H264 the check boxes will appear with some being enabled for use. Enabling some of the check boxes is where I had problems. Below are the options I came up with - with my preferences in order. But I open to suggestions if anyone has anything better or easier.

My 1st option was to disable/lock (or prevent the user from being able to click on the check box) certain check boxes if H264 =1 but I could not figure out the VBA code. So option 2 was to perhaps determine a way to change the color of the actual check-mark to white when H264 =1 to give the effect that the check boxes are disabled even if the user clicked the check box. But I could not determine how to do that either.

So I went to option 3 (my least favorite option), which would be to fill the interior color of the check box to black so if the user clicks the check box, you cannot tell it has been checked because the check-mark is black and the check box is filled black - so it essentially has the effect of being disabled.

My VBA knowledge is limited. Below is what I have but this doesn't fill the interior of the check box. It instead fills the outer edge of the check box.

Please Login or Register  to view this content.

I appreciate any help offered.

It looks like the checkboxes are always visible, so you could do something like this to change the enabled status of the 4 and also grey the check out using the mixed status.

Please Login or Register  to view this content.

Maybe this?

Please Login or Register  to view this content.

I appreciate your response. This isn't quite working for me. When H264 is 1 or 2, the checkboxes are the same. They are all supposed to be disabled when H264 is 2. Also, the mixed (or greyed) doesn't really disable the checkbox. The user can still click the checkbox and make a check-mark appear. Was hoping for a way to dis-allow the user from being able click the box or being able to see the check-mark.

It works for me. Maybe post your workbook?

ByteMarks -
Apologies for delay. I have attached the workbook as suggested. I tried re-writing the code (somewhat started over) with partial luck. Your code with the checkboxes are a perfect solution if I can understand the code and get them working completely. Thanks so much for the suggestion!! The checkboxes do somewhat work now but I am still doing something wrong. I'm not sure I understand the code.

There are 3 sections I need the checkboxes to enable and disable checkboxes (Gender, Ethnicity, and Race). I figure if I can get the Ethnicity working, I hoping I can figure out the other 2 sections. So in testing myself to see if I understand the code, I tried writing it out differently for the Gender section but it didn't work, so I don't think I understand some of the lines but I'm not giving up.

Perhaps I'm missing it in the coding but I'm looking for where it enables some checkboxes while disabling the others (looks like now either all are enabled
or disabled). I've included notes below as well as in macro.

When H264=0 All checkboxes are unlocked
When H264=1 2 checkboxes are unlocked and others are locked
When H264=2 All checkboxes are locked

Thanks!

This explanation was REALLY helpful. Thanks so much. But how to do I apply that for each section? I write this code for each section. Is that how I should have done it? Works perfect for Race, but it enables and disables the checkboxes in the Gender section as well as the Ethnicity section. If the data is collected in person, the patient may not be willing to provide Ethnicity so only the bold items Not Hispanic and Hispanic checkboxes would be enabled in that section but the patient may not willing to provide Race so all of the checkboxes in the race section would be enabled. Each section has its' own indicator so I wrote the code for each section but didn't end with quite the right results.

I would have a separate Sub for each section which will make testing and working out the enabled states easier.
I'd also give the checkboxes a section-specific name e.g. Gender1, Gender2 etc.
Then you can you can work out the enabled states and triggers for each section and test it.

If each section's boxes will operate independently of other sections then you could group them and then loop through the group rather than every box on the worksheet.
So, if you grouped Gender1 and Gender2 in a group called GroupGender

Please Login or Register  to view this content.

It took several tries, but I got it! ByteMarks - I really appreciate your help and the explanation to the code. It was a BIG help for a newbie like myself!! Thanks again and have a great week!

Well done, that's great. I'm pleased I was able to help.