Change linked cell in check box

I have this code that works perfectly to add checkboxes down a column according to the current selection of cells on the sheet. The code creates a linked cell under each check box as it inserts each one. I want to change the linked cell address so that it is on the same row as the box but in Column "AA" instead of the same column of the checkboxes. look for .LinkedCell=c.Address
Here is the code:

Please Login or Register  to view this content.

Hi JJGF,

Please take a moment to go over the Forum rules again, and wrap your Code as per the specified requirement.

Hi JJGF,

Good! Thank you for sharing it with the Forum.