Excel VBS macro to modify form control : I am wanting to create a macro in Excel 2013 that will modify the linked cell of a check box.

For example, say I have a buttload of check boxes in column D that I want to link to D1, D2, D3, all the way to D999999 or whatever.  I can use a loop to do the repetitive part, but I don't know how I can tell it to change the linked value.

Thank you!