Not really unless you are lucky. The checkboxes like all controls arren't
linked to the worksheet. The textt box location is specified in X-Pixels and
Y-Pixels. Cells on worksheets also have a Pixel location. Using a macro it
is difficult to associate a control with a cell but it can be done.

It would be easier if the names of the check boxes where is some sort of
order like checkbox 1 is on cell B1 and checkbox 2 is on cell B2 and so on.
The name of the check box can be anything as long as the numbers are in
order. A simple macro can be written to go down a list of names in order and
add the LinkedCell property. Thats why I said if you are lucky.

"Steve Jones" wrote:

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