Miscellaneous lessons from the Expert Skills course. - 09-03 Set Cell Links for Excel Combo Box & Group Box (Option Buttons)

When an Excel user selects an item from a Combo Box or Group Box (option button) form control the result is sent to an Input Cell. The Input Cell is defined using the control's Cell Links property. This lesson will teach you best practice when creating worksheets that contain controls. You'll learn how to correctly design a worksheet to use Input Cells and Result Cells to separate the user interface from the calculation area of the workbook. 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 and 09-02. These are the lessons where best-practice techniques was used to add the controls you see to the sample file workbook. ⌚ Timestamps 0:00​ Sample file download instructions, download link, and discussion of sample file. 0:10 Set AutoHide Ribbon and re-scale the worksheet so that everything is visible on screen. 0:36 Explanation of the importance of separating the user interface from Input and Result cells. 1:37 Connect the values of three cells in the User Interface to three of the Input Cells. 2:24 Connect the Deposit Group Box control (a set of option buttons) to the Deposit Input Cell. 4:09 Connect the Term Group Box control (a set of option buttons) to the Term Input Cell. 5:25 Connect the Interest Combo Box control to the Interest Input Cell. 8:15 Link to next lesson, course session playlist and to download sample file set.