Page 429 - Computer Software Application TP - Volume 1

COMPUTER SOFTWARE APPLICATION - CITS

EXERCISE 70 : Create and modify simple macros

Objectives

At the end of this exercise you shall be able to
• create simple macros
• modify macros.
Requirements

Tools/Materials
• PC/Laptop with Windows OS
• MS Excel 2013 or Higher
Procedure

TASK 1: Area of a rectangle
Step 1 : Open MS Excel and press Alt+F11 to activate Visual Basic Editor
Step 2: Develop the Interface ie., Place the required Controls from Developer tab in the Excel Sheet and Set
the Properties .

Step 2.1: To set the property Right Click on each controls (CommandButton1& CommandButton2) and select
‘properties’ from the drop down menu.

414