Excel Macro to Link all Checkboxes to a Cell

When inserting checkboxes on an Excel worksheet you have to set the cell to link them to. You cannot use relative references for these cell links, making it a tedious task. This video tutorial will show you how to create a macro that sets the cell link for all the checkboxes on a worksheet. The ability to create macros in Excel is a fantastic skill to have. Just like in this video, you can create macros that will save hours of time and improve the accuracy of your work. Take the complete Excel VBA course - http://bit.ly/37XSKfZ Below is the Excel VBA code used to create the macro in this video. You can copy and paste this code and adapt it as necessary. Sub LinkChecklist() Dim chk As CheckBox For Each chk In ActiveSheet.CheckBoxes chk.LinkedCell = chk.TopLeftCell.Offset(0, -1).Address Next End Sub