Duration: 2 days

Course Content:
  1. Introduction and Need for VBA

    • 1.1. Advantages & Disadvantages of VBA
    • 1.2. Macros for automation
    • 1.3. User-Defined Functions
  2. Interface & Structure

    • 2.1. Settings – Developer Tab, Macro Security,File types
    • 2.2. Macro Recorder
    • 2.3. VB Editor & Components
  3. Sub procedures & Function procedures

    • 3.1. Subs versus Functions
    • 3.2. Executing Sub procedures
    • 3.3. Executing Function procedures
  4. VBA Language Elements

    • 4.1. Variables, Constants & Data Types
    • 4.2. Assignment Statements
    • 4.3. Using Labels
  5. Program Flow and Logic

    • 5.1. Declaring Variables
    • 5.2. Flow Control Structures
    • 5.3. Looping
  1. Events

    • 6.1. Triggering the code – Events
    • 6.2. Event-handling Procedures
    • 6.2.1. Worksheet-level events
    • 6.2.2. Workbook-level events
  2. Error Handling & Debugging

    • 7.1. Run-time Errors
    • 7.2. The “On Error” Statement
    • 7.2.1. On Error GoTo label
    • 7.2.2. On Error Resume Next
    • 7.2.3. On Error GoTo 0
    • 7.3. The “Resume” Statement
    • 7.3.1. Resume
    • 7.3.2. Resume Next
    • 7.3.3. Resume label
    • 7.4. Debugging
    • 7.4.1. Types of bugs
    • 7.4.2. Debugging Techniques
  3. Interacting with Users

    • 8.1. Need for and various ways of user interaction
    • 8.2. Simple dialog boxes – MsgBox and InputBox functions
    • 8.3. Other built-in dialog boxes –GetOpenFileName method,GetSaveAsFilename method, FileDialog object, Application.Dialogs
  4. Working with Add-ins

    • 9.1. Need for Add-Ins
    • 9.2. Creating, opening / enabling, and modifying Add-Ins
    • 9.3. Sharing your code