Page 440 - Computer Software Application TP - Volume 1

COMPUTER SOFTWARE APPLICATION - CITS

EXERCISE 71 : Perform form controls and create simple

data entry form with macros

Objectives

At the end of this exercise you shall be able to
• create simple data entry form with macros.

Procedure
User form is a customised interface, developed in VBA. It enables a user to interact, using a form, in an organised
and logical manner or to enter data and retrieve data with an Excel Worksheet or Run a VBA application.
• User Forms acts as a container in which you add multiple controls, each of which has a specific use and
associated properties.

TASK 1: Create a User Form – Employee Salary Details

• Step 1: Navigate to VBA Window by pressing Alt+F11 and Navigate to “Insert” Menu and select “User Form”.
Upon selecting, the user form is displayed as shown in the following screenshot.

• Step 2: Design the forms using the given controls.

425