Another way to add functionality to your workbooks is to use Excel’s Form Controls. By using form controls, you can provide a user friendly way to make choices and selections on a worksheet. You can arrange form controls to allow users to perform calculations and get results without having to interact directly with the source data. You can assign a macro to a form control, and you can even use form controls to create a customized user interface for a workbook.

 

In this lesson, you will learn what a form control is, and how to access them. You will learn how to add a control to a worksheet, and how to assign a macro to a control. Finally, you will learn how to use controls build a simple form, to accept and manipulate user information.

 

 

The form control toolbar.