"Check Boxes" copy and paste

[Ross]

We use check boxes on some of our internal forms. When you
tick off a check box it puts true into the cell - say H15
or whatever cell the checkbox is in.

One form involves dozens of checkboxes, so setting it up,
we would like to set up one row of checkboxes, then copy
and paste that row, rather than manually set the check box
references to J15, K15,.... You'd expect that to change
automatically like most cut and paste operations.

However, whether due to a bug or some feature I don't know,
if you copy and paste a check box, it continues to refer
back to H15.

Does anyone know how to make it paste properly (we tried
all the various paste special options, and that doesn't help.

Thanks in advance,

Ross.

 

[Andy Brown]

However, whether due to a bug or some feature I don't know,

if you copy and paste a check box, it continues to refer
back to H15.

No bug, that's how they work.

You could try this code John Walkenbach posted a year back. It'll link each
checkbox to its respective cell.

HTH,
Andy

Dim cb As CheckBox
For Each cb In ActiveSheet.CheckBoxes
cb.LinkedCell = cb.TopLeftCell.Address
Next cb