Specifications

222 Chapter 13
Use of Macros
Making/Editing Macros
• User form
The program (procedure) is shown on the control pasted on the user form. The
extension “*.frm” is attached to a user form.
Step 1. User form is added to a project by the following menu command.
Insert - UserForm
After the user form is added, the code window describing its code is not displayed but
can be viewed double-clicking on the appropriate control on the user form.
• Class module
Class module is used to make an object in Visual Basic that can be used from another
application. This class is actually a template for making an object for Visual Basic. The
extension “*.cls” is attached to a class module.
Step 1. Class module is added to a project by the following menu command.
Insert - ClassModule