Hi - I've been trying to come up with a way to disable checkboxes based on a true/false condition. Sounds simple, eh? Well, maybe not.
I looked around for a simple way to do this in VBA. Here's what I want to do:
Let's say I have 3 ranges of cells: C2:C6 has true/false values from E2-E6 which have checkboxes connected to them. D2-D6 has text in them that according to my conditional formatting turn grey if the adjacent cell(s) - C2-C6 - are FALSE. I tried a loop to disable the checkboxes based on this, but seems to disable ALL of them.
On Error Resume Next
Dim c As Range, myRange As Range
Set c = [C2:C6]
Set myRange = selection
For Each c In myRange.Cells
If c.Value = "False" Then
.Enabled = False