What is Macro

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

·         Worksheet Object

·         Range Object

Excel application consists of one or more Workbooks

Workbook consists of one or more worksheets

Each worksheet consists of Range of cells