Need to modify this macor a bit

[billerbong]

OK this macro looks for any check box and then links the check box to a specific row and cell in this macro. What I want to be able to do is just select all check boxes in a column instead. Let me know and thank you for any help on this.



Option Explicit
Sub LinkCheckBoxtoCell()
Dim CBX As CheckBox
For Each CBX In ActiveSheet.CheckBoxes
With CBX
.LinkedCell _
= .Parent.Cells(.TopLeftCell.Row, "R").Address(external:=True)
End With
Next CBX

End Sub