How does one remove the text from check box. I just want the checkbox with black outline.
I have this.
![]()
Sub Test() Dim Rng As Range Dim c As Range Dim Ctrl As Object Set Rng = Range("A1:A10") For Each c In Rng Set Ctrl = ActiveSheet.CheckBoxes.Add(c.Left, c.Top, c.Width, c.Height) With Ctrl .LinkedCell = c.Offset(0, 1).Address End With Next c End Sub
Bookmarks