VBA SYLLABUS

VISUAL BASICS FOR APPLICATION [VBA]

Module 1: Introduction To VBA
Module 2: Advantages Of VBA
Module 3: Understanding the VBA Editor, Module & Procedures
Module 4: VBA Syntax & Grammar
Module 5: Variables, Arrays & Constants
Module 6: Sorting Data in Variables
Module 7: Control Structure & Program Flow
Module 8: Building Procedures
Module 9: Building Intuitive User Interfaces
Module 10: Creating Customized Dialogs with User from Objects
Module 11: Fonts & Background
Module 12: Objects & Collections
Module 13: Arrays
Module 14: Functions
Module 15: Internet & Excel
Module 16: Interacting with Other Office Applications
Module 17: Running SQL Queries Within Excel Environment
Module 18: Modifying Menus & Toolbars

VBA CURRICULUM