We offers professional excel macro training in delhi. By the end of the VBA course Learners will be able to Understand Excel VBA’s strengths, weaknesses and limitations. They will be able to Plan, write, debug and extend structured VBA code. Our Excel macro training includes lab assignment and projects for better understanding.

Introduction of VBA

  • What is VBA
  • Advantage of VBA
  • The First Excel Macro
  • Recording and executing macros
  • Using the VBA Editor

Variables and Data Types in VBA

  •   Declaring Variables
  •   Variable Names
  •   Scope of Variables
  •   Putting Values in Variables
  •   Creating Constants
  •   Data Types
  •   Storage and Data Sizes

VBA Operators and Expressions

  •  Simple Arithmetic Operators
  • Relational or Comparison Operators
  • Concatenate Operators
  • Logical Operators
  • Order of Operations
  • Mathematical Expressions

Conditional branching

  •  If…Then…Else
  • Select…Case

Looping

  •  While….wend
  •  For…Next
  •  Do…While
  •  Do… Until
  •  For Each…Next
  •  EXIT Statement

Arrays

  • What an Array Is
  • Creating Arrays
  • Resizing Arrays
  • Two-Dimensional Arrays

Functions and Procedures

  • Creating a Subroutine
  • Understanding Parameters
  • Parameter Passing
  • Function vs Procedure
  • Return Statement
  • Arrays as Parameters
  • Using Functions in Formulas
  • Mathematical Functions
  • Conversion Functions
  • String Functions
  • Working with Dates

Event-driven programming in VBA

  • The role of events in Windows
  • Responding to events through event procedures

Excel Object Model

  • Properties
  • Methods
  • Events
  • Collections
  • With…End With
  • Worksheets
  • Workbooks
  • Ranges (Cells)
  • Charts

Creating User Form

  •  Command buttons
  •  List and Combo boxes
  •  Labels
  •  Option buttons
  •  Check boxes
  •  Text boxes
  •  Frames

8 thoughts on “Excel Macro

  • September 22, 2017 at 4:40 am
    Permalink

    For VBA course, weekend batch & fees please?

    Reply
  • October 26, 2017 at 9:07 am
    Permalink

    I wanted to know the duration of the entire course and the price of the same.

    Reply
  • January 12, 2018 at 1:15 am
    Permalink

    Hi,
    Ganesh this side and may I know the course duration , course timing, coaching hour and fee structures of VBA AND SQL course.

    Reply
  • March 5, 2018 at 5:05 pm
    Permalink

    Hi. .I want to know duration of VBA course if I take classes on Sunday only and along with fees.

    Reply
  • April 2, 2018 at 8:11 am
    Permalink

    Hi,
    Myself Vipin Kumar, I want to know VBA course Fee for Saturday and sunday only.

    Reply
    • April 8, 2018 at 9:32 am
      Permalink

      Hi,

      plz give your contact number, so can explain about excel vba course duration and fee.

      Reply
  • July 26, 2018 at 12:43 pm
    Permalink

    Hi,
    I want to to VBA on weekends. Would like to know about the weekend batches, course duration & fees.

    Reply
  • April 24, 2019 at 6:18 am
    Permalink

    hello I am interested in VBA Course. Request you to share the quotation for the same

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *