Microsoft® Office System Step by Step -- 2003 Edition

Chapter 10 Simplifying Data Entry with Forms

Using Visual Basic for Applications to Enter Data in a Form To create a form by using a wizard

1. On the Objects bar, click Forms.

2. Double-click Create form by using wizard to display the first page of the Form Wizard.

3. Follow the instructions of the Form Wizard, and then click Finish.

Using Visual Basic for Applications to Enter Data in a Form To change the properties in a form

1. Display the form in Design view.

2. Use the buttons and boxes on the Formatting toolbar to change the formatting of labels and controls.

3. To change the properties of a control, in the form, right-click the control you want to change, and click Properties from the shortcut menu.

4. Click the appropriate tab, click the property you want to change, ...