Good Afternoon
I have looked around and tried several different codes posted online but I cant get them to work, What I want to achieve is as follows
when a cell is blank I want the active x check box not to be visible but when the cell is populated by a formula I want the check box to be visible.
I have formula in cells B25:B39 and a checkbox next to each row so ideally I need the check boxes hidden on every line until the corresponding line is populated if possible.
Here's a code I tried as a starting point
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("B25:B39")) Is Nothing Then Exit Sub
If Target.Value <> "" Then
Me.Shapes("Check Box").Visible = True
Else
Me.Shapes("Check Box").Visible = False
End If
End Sub
Bookmarks