I am building a template, which I'd like to contain numerous check boxes. I
may have up to 10,000 or more check boxes, 10 per row, 1,000 rows. Is there
a way to copy and paste one row, and have the pasted check boxes linked cell
update automatically? In other words, if I have one check box per cell in
row 9, and each is linked to the cell in which it is contained, (i.e. b9, c9,
d9, etc.) I would like to repeat the format on the next 500 - 1000 rows,
having each control linked to its respective cell. So, the column would stay
the same, and the row would change. Is there a way to do that without having
to enter the properties or format control and changing each one separately?

Thanks in advance,
Jason