I have placed Check boxes from the forms toolbar in cells A1:A300

In format control I want the cell links to be say B1 for A1, B2 for A2 etc.

Is there an easy way to copy the formats down?

Thanks very much