Welcome to Wings Academy

VBA MACRO

VBA MACRO

VBA MACRO 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

Trainer Profile of VBA MACRO Training
Our Trainers provide complete freedom to the students, to explore the subject and learn based on real-time examples. Our trainers help the candidates in completing their projects and even prepare them for interview questions and answers. Candidates are free to ask any questions at any time.

  •  More than 7+ Years of Experience.
  •  Strong Theoretical & Practical Knowledge.
  •  Certified Professionals with High Grade.
  •  Well connected with Hiring HRs in multinational companies.
  •  Expert level Subject Knowledge and fully up-to-date on real-world industry applications.
  •  Our Trainers are working in multinational companies such as CTS, TCS, HCL Technologies, ZOHO, Birlasoft, IBM, Microsoft, HP, Scope, Philips Technologies etc