VBA / Macros Training

Learn how to automate your work in Microsoft Excel with Visual Basic for Applications.

Visual Basic for Applications (VBA) is a scripting language developed by Microsoft which allows the development of user-defined functions and the automation of certain processes and calculations. VBA is built into most Microsoft Office applications to extend their functionality. It can be used to control many aspects of the host application, including manipulating user interface features, such as menus and toolbars, and working with custom user forms or dialog boxes.

Course contents

  • Introduction to VBA

    What Is VBA?

    VBA: An Event Driven Programming

    VBA: An Object Based Programming

    What Can You Do with VBA?

    Advantages and Disadvantages of VBA


  • Getting Started With Macro

    Recording the Macro

    Examining the Macro

    Saving Workbooks That Contain Macros

    More about the Macros

    The Personal Macro Workbook

    Types of Modules


  • The Excel Object Model

    The Object Hierarchy


    Referring to objects

    Navigating Through the Hierarchy

    Object Properties and Methods


  • VBA Language




    Data Types

    Procedures: Sub and Function


    Procedures: Public or Private

    Control Flow Statements

    Loop Statements


    The Application Object

    Using VBA and Worksheet Functions

    Automatic Procedures and Events

  • Workbooks and Worksheets

    The Workbooks Collection

    The Sheets Collection

    Using Ranges



    Data Lists

  • Programming Examples

    Copying a range

    Copying a variable-sized range

    Selecting adjacent non-blank cells of a row or column

    Selecting a row or column

    Moving a range (Cut & Paste)

    Looping through a range

    Prompting for a cell value

    Determining the selection type

    Identifying a multiple selection

    Working with Charts

    Turning off screen updating

    01 hours

Course Details


30 - 35 hours approx.


Between 10am to 6pm

Weekend classes only.

What's covered?

VBA Macros

Contact Details

Mobile - +91 90600 39005

Landline - 080 4099 3798

Address 1375/8, 2nd Floor, East End Main Road, Jayanagar 9th Block, Bangalore - 69

All days

10 AM - 6:30 PM

Talk to us @

+91 9060039005

Note: We will never share your phone number or email address with any one, it will be used only by us to contact you regarding the courses at our institute.

paper plane with clouds

Request a Callback