checkbox property

[ranswert]

How do I write a procedure that selects a checkbox within a range of cells so
that I can change the cell that it is linked to and also change the name?
Thanks

 

[JLGWhiz]

I copied this from the VBA help file.

This example adds a check box to worksheet one and links the check box value
to cell A1.

With Worksheets(1)
Set cb = .Shapes.AddFormControl(xlCheckBox, 10, 10, 100, 10)
cb.ControlFormat.LinkedCell = "A1"
End With