VBA Training Syllabus

• 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 Mode
• Workbooks and Worksheets
• Error handlings
• Functions in VBA
• How to apply Worksheet functions in VBA
• Advanced User forms
• Connecting Data from Excel to User forms