form control cell link does not fill properly

  • Thread starter Thread starter Greg
  • Start date Start date
G

Greg

using excel 2000 (9.0.3821 SR-1)

I'm trying to track the completion status of items in a
spreadsheet, so I created a column and in the first row I
inserted a checkbox form control and entered A2 in the
Cell link property. If I then copy this and paste it into
A3 or if I fill down then the control copies fine except
the cell link property does not fill down. I.e. the box
in A3 should link to cell A3 and so on.

Am I expecting to much? Confused? Is there a work-
around? Should I just bite the bullet and write a macro
(ugly solution!) to update the cell links for each of the
checkboxes?

Any help is appreciated. Thanks.
 
the linked cell does not adjust in a control as you expect. This only
works with formulas. There really is not reason to expect that it would.

You don't have to use the "ugly solution" of a macro - you can edit each one
by hand.
 
Back
Top