Miscellaneous lessons from the Expert Skills course. - 09-05 Add an Excel check box form control to a worksheet without VBA

In this lesson you'll add an Excel Checkbox Form Control to a worksheet. The lesson is taught in the context of an elegant professional Mortgage Calculator worksheet and is used to indicate whether a loan is Interest Only. As with all video lessons from The Smart Method®, there's a sample file download link at the beginning of the video to enable you to work along with the lesson. You may, however, get more from this lesson if you first work through lessons 09-01, 09-02, 09-03 and 09-04. These are the lessons where best-practice techniques was used to add the controls and functionality you see to the sample file workbook. ⌚ Timestamps 0:00​ Sample file download instructions, download link, and discussion of sample file. 0:20 Make some space on the worksheet for the checkbox control. 1:00 Insert a CheckBox form control into the worksheet. 1:30 Set the caption (text) property for the checkbox. 2:12 Add a new input cell to accept the value of the checkbox. 2:29 Set the Cell Link property of the check box control to connect it to the new input cell. 2:48 Test the CheckBox to make sure that it is working as expected. 3:35 Link to next lesson, course session playlist and to download sample file set.