Description

This course makes you acquainted with the VBA for MS Excel environment. It helps you understand the components of Sub (Macro) and Function procedures written in VBA, record and edit macros, get acquainted with various objects in MS Excel and their properties and methods. At the end you should gain confidence to start coding and exploring VBA and be able to handle errors in their code and use various debugging techniques.

Additional information

Day 1

Module 1. Introduction and Need for VBA
    1.1. Advantages & Disadvantages of VBA
    1.2. Macros for automation
     1.3. User-Defined Functions
Module 2. Interface & Structure
     2.1. Settings – Developer Tab, Macro Security,
            File types
    2.2. Macro Recorder
    2.3. VB Editor & Components
Module 3. Sub procedures & Function procedures
    3.1. Subs versus Functions
     3.2. Executing Sub procedures
     3.3. Executing Function procedures
Module 4 .VBA Language Elements
    4.1. Variables, Constants & Data Types
    4.2. Assignment Statements
    4.3. Using Labels
Module 5. Program Flow and Logic
    5.1. Declaring Variables
    5.2. Flow Control Structures
    5.3. Looping

Day 2

Module 6. Events
    6.1. Triggering the code – Events
    6.2. Event-handling Procedures
          6.2.1. Worksheet-level events
          6.2.2. Workbook-level events
Module 7. 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
Module 8. 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
Module 9 :Working with Add-ins
   9.1. Need for Add-Ins
   9.2. Creating, opening / enabling, and modifying
        Add-Ins
   9.3. Sharing your code

Reviews

There are no reviews yet.

Be the first to review “Visual Basic for Applications (VBA) for Excel”