v Macro is a code which consist of set of instruction, utilized to execute particular task.

v These macros are utilized to eliminate the repetitionof steps while executing particular task.

v These are very beneficiary for users while executingregular repetitive tasks.

"Sub" represents to "Sub-Procedure"
VBA code must be written "Sub" and "End Sub" only

About Macro Dialogue Box

Macro Dialogue box consists of

v Macro Name

v Shortcut Key

v Location where macro stores

v Description

Here is the brief explanation regarding the Macro Name

Shortcut code for Small Letters

CTRL + Character

Shortcut code for Capital Letters

CTRL + Shift + Characters

About Objects of VBA

VBA is Object based language.
Object hierarchy has been mentioned below

VBA consists of three objects

· Workbook Object

Excel application consists of one or more Workbooks

Workbook consists of one or more worksheets

Each worksheet consists of Range of cells