Changing LinkedCell of Checkbox

[sfran]

Hello, I am trying to change the LinkedCell of a Checkbox. The LinkedCell must point to a cell in the second-to-last worksheet of the workbook.

I have several checkboxes who's LinkedCell must change.. all point to the same worksheet, but different cells. The below code is what I currently have for one of the checkboxes. This seems to work fine for Excel 2016, but fails when run in Excel 365:

ActiveSheet.CheckBoxes("RADFW").LinkedCell = "'" + Sheets(Sheets.Count - 1).Name + "'" + "!" + "A30"

Is there a different way to change the LinkedCell of checkboxes?

Any insight is greatly appreciated.

 

[Fluff]

Duplicate to: International error running macro's

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.