Facets Demo New Batches Starting from Saturday... 22-10-2016
Search Course Here

Live Chat

Excel VBA


VBA (Visual Basic for Applications) is the programming language of Excel and other Office programs.

VBA stands for Visual Basic for Applications an event driven programming language from Microsoft that is now predominantly used with Microsoft office applications such as MS-Excel, MS-Word and MS-Access.

Ecorptrainings is an excellent Advanced Excel VBA training institute in Hyderabad India. Our course module will enable you to master this very helpful software, and make the process of analysis much quicker to grasp and implement.


  • The delegates must have a good knowledge of Excel.


  • It is a 8 days program and extends up to 2hrs each.
  • The format is 40% theory, 60% Hands-on.

  • It is a 2 days program and extends up to 8hrs each.
  • The format is 40% theory, 60% Hands-on.
    Private Classroom arranged on request and minimum attendies for batch is 4.

course content

  • Visual Basic Editor

    • Visual Basic for Applications
    • Object Programming
    • Event Procedures and Macros
      • Event Procedures
      • Macros
    • Using Help
      • Getting Help in the Object Browser
    • Using the Visual Basic Editor in Excel
    • Saving and Running a Procedure
  • Programming Basics

    • Data Basics
    • Scope of Variables
      • Reserving a Procedure-level Variable
    • Naming Variables
      • Selecting the Appropriate Data Type and Name for a Variable
    • Using Variables to Accept User Input
      • Reserving a Procedure-level String Variable
      • The InputBox Function
      • Concatenating Strings
  • Control Structures

    • Decision Structures
      • Using the If Then Else Statement
      • Nesting If Then Else Statements
    • Using the Selection Structure in Excel
    • Coding the Calculator Procedure
    • The Select Case statement
      • The Select Case Statement
  • Custom Dialog Boxes

    • User Forms
    • Adding a Form
      • The Toolbox
      • Sizing, Moving, Deleting, and Restoring a Control
    • Using the Custom Dialog Boxes in Excel
      • Adding a Form
      • Control Properties
    • The Update Inventory Dialog Box
  • Debugging and Error Handling

    • Errors
    • Automation and Error Trapping
      • Using the GetObject Function
      • Intercepting and Handling Run-time Errors
      • Preventing Multiple Instances of an Application
    • Using Automation and Error Trapping in Excel
      • Modifying the OpenMemo Procedure


For Videos Click Here Videos
  • excel vba course
  • excel vba course in hyderabad
  • excel vba training course content in ecorp trainings
  • excel vba online training from india

Flash News

AngularJS New Batch Start From 09th OCT & 10th OCT.

Hadoop Dev New Batch Start From 10th OCT & 11th OCT.

IBM COGNOS TM New Batch Start From 11th OCT & 12th OCT.

Informatica Dev New Batch Start From 12th OCT & 13th OCT.

Mean Stack New Batch Start 13th OCT & 14th OCT.

SAP BODS new Batch Starting From 14th OCT & 15th OCT.

SAP S/4 HANA New Batch Start From 15th OCT & 16th OCT

Tableau New Batch Start From 16th OCT & 17th OCT


Facets Demo Training

Demo Schedule : 08:30P.M EST / 07:30P.M CST / 05:30P.M PST on 21st OCT & 06:00A.M IST on 22nd OCT
Email :
Rediff Bol :
Google Talk :
MSN Messenger :
Yahoo Messenger :
Skype Talk :