I have many checkboxes (1 to 26) that I want visible or not, based on whether the cell states "n/a" (are in a column in a different worksheet). Rather than writing this code multiple times, I'm looking to condense the code.
If Worksheets("SelfCare").Range("E3") = "n/a" Then
CheckBox1.Visible = False
Else
CheckBox1.Visible = True
End If
If Worksheets("SelfCare").Range("E4") = "n/a" Then
CheckBox2.Visible = False
Else
CheckBox2.Visible = True
End If
If Worksheets("SelfCare").Range("E5") = "n/a" Then
CheckBox3.Visible = False
Else
CheckBox3.Visible = True
End If
Bookmarks