Use below links to quickly learn about Form Controls: You can use that numeric value in conjunction with the Offset, Index or other worksheet functions to return values from lists. Buttons allow execution of VBA code.īy adding a control to a worksheet and linking it to a cell, you can return a numeric value for the current position of the control.
Option Buttons and Check Boxes allow selection of various options. For example, drop-down boxes, list boxes, spinners, and scroll bars are useful for selecting items from a list.
You can use these controls on worksheets to help select data. Form Controls are objects which you can place onto an Excel Worksheet which give you the functionality to interact with your models data.