Session : 1 – 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

Session : 2 – 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

Thanks for the best ever Training. I did my Android Course here. Trainer is very good in knowledge. They provides the best ever Support to me.

Kaviya