Module 1: Understanding Security Levels
Why security
Security levels and its meaning
Module 2: Functions
What is Function and Subroutine
Writing Functions using VBA Editor
Calling function in other workbook
Module 3: Recording Macros
Recording and running macro
Storing macro in different books
Creating buttons and assigning macro to it
Creating My Menu
Module 4: The Visual Basic Editor
Editing macros using VBA Editor
Understanding the project explorer
Exploring windows properties
Modifying code in code window
Debugging code
Module 5: Programming Fundamentals
Variables, data types and constants
Arrays
Object Variables
Conditional structures (If …. Then, Select Case)
Logical Operators
Looping constructs (For loops, Do loops, while… Wend)
Built-in functions
Creating Subroutines
Module 6: Excel Object Model
Working with objects – properties, events and methods
Application objects
Workbook objects, Worksheet objects and Range objects
Charts objects
Pivot table objects
Module 7: User Forms
Creating forms
Form events
Creating custom menus and toolbars
Creating Add-ins
Module 8: Working with other applications
Working Word, PowerPoint and other applications.