We are developing worksheets where we have a tall column of checkboxes with
the checkbox linked to the cell beneath each control. We also want to
sequentially name each control, starting at the top of the column, with a
standard prefix concatenated to a sequential number. Next, we want to link
each of those controls with the cell directly beneath it.

Understandably, manually typing the '(Name)' and 'LinkedCell' property for
each control is a bit frustrating. Unlike, copying formulas down a column,
the linked cell reference for the control does not automatically adjust the
cell link as a new control is pasted over a new cell. Does anybody have any
thoughts on simplifying or automating this process?