Most spreadsheet controls need to link to a cell to enable interaction with the spreadsheet. There is an easy way to do that.

Let’s use a check box as an example. A checkbox returns TRUE or FALSE depending on whether it is ticked (TRUE) or not (FALSE).

To link the check box to a cell, first create the check box.

With the check box still selected click in the Formula Bar and press = and click on the cell to link to and press Enter. That’s it, done – see images below.

Cell B3 has been linked to the check box.