• What is VBA?

• Why need to do programming for MS-Excel.

• What can we do with Excel VBA? (Few interesting examples)

• Using the development Integrated Development Environment.

• The project explorer - Introduction to the VBA project concept and project components

• The property Window.

• The IDE main menu

• Switching between Excel normal interface and IDE interface.

• Help system.

• Why we need automation in MS-Excel?

• What is macro?

• Recording macros

• How to trigger macros from Excel normal interface?

• How to trigger macros from VBA IDE?

• The immediate window

• What is instruction?

• Evaluation instructions

• Command Instructions

• Dealing with Excel VBA objects and their properties

• Single cell reference methods

• Range reference methods

• Inter-worksheets reference

• Inter-workbook reference

• The Procedure concepts

• Procedures (Subroutines)

• Procedures (Functions)

• Procedures (Event Handlers)

• Pre-mature terminations with Exit keyword

• Grouping instructions using With statement

• Why is module needed?

• Code Module

• User Form in brief

• Class module in brief

• Worksheet module in brief

• Workbook module in brief

• Procedure’s scoping

• Dealing with ambiguities

• Type of errors

• Dealing with compilation errors

• Dealing with runtime errors

• Dealing with logical errors

• The debugger and debugging process

• Why are variables needed?

• Basic Data Types

• Variable declaration and shorthand

• Variable scoping and life cycle

• Variable initialization

• Option Explicit directive

• MsgBox function

• InputBox function

• Number functions

• String functions

• Date/Time functions

• Format function

• RGB function

• Comments

• VBA Constants

• Excel Constants

• Defining constants

• Selection keyword

• Application object

• ActiveSheet object

• Sheet’s collection

• Workbook’s collection

• What is parameter?

• Optional parameters and techniques to handle default values.

• Arbitrary argument support using ParamArray declaration.

• Parameter passing mechanisms: ByVal vs. ByRef

• Named arguments.

• What is operator?

• Arithmetic operators

• Comparison Operators

• Logical Operators

• Special Operators

• Unconditional Branching with GoTo statement

• Unconditional Branching with GoSub statement

• If..Then..Else Statement

• Select Case Statement

• Unconditional Loop with GoTo statement

• Using For Loop

• Using For Each statement

• Pre-test looping

• Post-Test looping

• Pre-mature termination using Exit keyword