Hi all
Checking if cell has checkbox. I have an array of cell addresses from a range (MyArr) and I want to highlight what addresses do not have a corresponding checkbox
I can list the addresses in the array that have a checkbox
i = 0
ReDim MyArr2(ActiveSheet.Shapes.Count)
For Each cb In ActiveSheet.Shapes
If Not IsError(Application.Match(cb.TopLeftCell.Address, MyArr, False)) Then
MyArr2(i) = cb.TopLeftCell.Address
i = i + 1
End If
but this doesn't give me the addresses that have no checkbox
i = 0
ReDim MyArr2(ActiveSheet.Shapes.Count)
For Each cb In ActiveSheet.Shapes
If IsError(Application.Match(cb.TopLeftCell.Address, MyArr, False)) Then
MyArr2(i) = cb.TopLeftCell.Address
i = i + 1
End If
any ideas??
Bookmarks