Checkboxes, macro and/or applescript

[fogharty]

I have a form with columns A-G, 1000+ rows.
Column G consists of check boxes, one for each row.
I need the linked cell for each checkbox to be the cell on which that
check box is located.
So Row 50, column G, the cell linked to is $G$50.

I have to do each link manually: Select checkbox, go to Format
Control, type in (or click in) the relative cell, then click OK, and
on to the next checkbox in the following row.

There should be some way to have this scripted, yes? I have tried to
do an Applescript as well as a macro (I'm working in Excel 2004 just
for the VBE) but I just can't get either to select the next checkbox,
then set the cell link to "Active Cell" or whatever. The most I can do
is have Excel activate.

Does someone know how I should be doing this? I'm a total novice when
it comes to VBE and applescripting.