Module Nine: Working with Forms

This module takes a closer look at forms. Really, all Excel spreadsheets are a type of form where you can enter data. However, we’ll take a look at data forms and form controls a little more closely as other ways to collect information with more flexibility. You’ll also learn how to create and use a data form, including adding a new row of data, finding information by navigating or by entering search criteria, and changing or deleting a row of data. Next, we’ll look at some specific examples of using different types of form controls. This module covers the list box control, the combo box control, the spin button control, and the scroll bar control.