Monday, August 26, 2013

How to Create a Worksheet Form in Excel 2003


1. Launch Microsoft Excel 2003. Start a new worksheet, or open the worksheet that you wish to add forms to.
2. Click 'Tools,' and select 'Customize.' The 'Customize' menu will appear.
3. Click the 'Toolbars' tab, and scroll down to 'Forms.' Place a checkmark next to 'Forms,' and click 'Close.' The 'Forms' toolbar will appear on your Excel spreadsheet.
4. Click on the type of form that you want to add to your Excel 2003 worksheet from the 'Forms' toolbar. You can add labels, group boxes, buttons, checkboxes, option buttons, list boxes, combo boxes, scroll bars and spinners.
5. Drag your cursor over the area in the worksheet where you want the form to appear, to create the form. You can edit and move the form after creation.
6. Right-click the form, and select 'Format Control.' The 'Format Control' dialog box will appear.
7. Edit the form using the options in the 'Format Control' dialog box. You can change the size, color, text and protection settings for the form.
8. Add macros to the forms by right-clicking the form and selecting 'Assign Macro.' The 'Assign Macro' dialog box will appear. Macros control the functions of the form.
9. Select a pre-created macro from the list of macros, and click 'OK' to use the macro or 'Edit' to open the Microsoft Visual Basic Editor so that you can write the code for the macro.

Blogger news