This video demonstrates how to add checkboxes to Excel cells.  A checkbox can be linked to a cell so that if it is ticked the cell receives the value TRUE and if unticked the cell receives the value FALSE.  The TRUE and FALSE values can be used to apply conditional formatting or within logical tests.

Download the featured file here.

Here is the featured VBA code.

Sub AssignCell()

Dim cbox As CheckBox

For Each cbox In ActiveSheet.CheckBoxes
     cbox.LinkedCell = cbox.TopLeftCell.Address
Next cbox

End Sub

Posted by Blue Pecan Computer Training