Visual Basic

VBA (Visual Basic Application) is a programming language to write the Macro coding in the Excel that helps in automation of the works that we do daily. Not only automation in the Excels, we can automate the other MS-Suite applications through Excel VBA to simplify the tedious jobs like in Word, PPT, Access besides the other external applications like C++,JAVA, AUTOCAD, CATIA…… whichever the DLL is available to automate

VBA is loaded with wide range of libraries that helps us to simplify the high complexity jobs that we perform on the other external or MS-Suite applications. It helps us to reduce the time in performing the tasks, increase in efficiency and qualitied results.

VBA opportunities are evergreen in market. Every Industry requires professionals who can analyse the data and helps in the decision making for the management. VBA stands for Visual Basic Application but known for its Very Big Automations.

 

VBA Training Syllabus

Basic topics

  • Introduction
  • How to add Developer Tool bar
  • Options in Developer Tool bar
  • Record a Macro
  • Edit the recorded macro
  • ActiveX Controls
  • Form Controls
  • Excel dialog Sheets
  • Options is VBA Screen
  • Enable properties
  • Views in VBA Screen
  • Locking of projects
  • Run option
  • Break options
  • Immediate Windows
  • Basic User forms
  • References
  • Object library

Advanced Topics

  • Working with VBA Editor
  • Option Explicit/Base coding
  • Worksheet Events
  • VBA Programming Concept
  • VBA Syntax and Semantics
  • Variable types and Declarations
  • Repeating Actions with Loops
  • Procedures
  • File handling
  • Controlling 3rd party applications
  • Excel Object Model
    • Application Object
    • Workbooks and Worksheets
    • Ranges and Cells
    • Numerical and String Functions
    • Dates and Time
    • Formatting Excel Objects
    • Files Import and Export
    • Excel Event
  • Error handlings
  • Functions in VBA
  • How to apply Worksheet functions in VBA
  • Advanced User forms
  • Connecting Data from Excel to User forms