Training Course Outline

Macros

Recording and Modifying Macros

Assigning Macros to Toolbar, Buttons, Shortcut key

Visual Basic for Applications Environment

Visual Basic Editor and its options

Component Management

Shortcuts

Environment Optimization

Introduction to Procedural Programming

Procedures: Functions and Sub-routines

Data Types

Control Flow

If ...Then....Elseif....Else....Endif

Case

Do...Loop , While

For... Next

Exit

Arrays and Loops

Strings

Visual Basic

VBA and Sheet Data Exchange (Cells, Range Methods)

Getting and Printing Data from Users (InputBox, MsgBox)

Variable Declaration

Scope and LifeTime of Variables and Objects

Operators and Their Priorities

Modules Options

Creating Worksheet Functions

Objects, Classes, Methods and Properties

Locking Project for Viewing

Debugging

Run Time, Design Time, and Break Mode

Brakes and Watches

Local Window

Immediate Window

Call Stack

Error Handling

Errors Types

On Error GoTo

On Error Resume Next

Excel Model Object

Application Object

Workbook Object and Workbooks Collection

Worksheet Object and Worksheets Collection

ThisWorkbook, ActiveWorkbook, ActiveCell, ....

Selection Object

Range Collection

Cells Collection

Using Status Bar

Screen Updating and Optimizing

Timer and Time Measuring

Events Handling in VBA

VBA Forms

Creating and Using Forms

Invoking Forms in VBA Code

Using VBA Forms in Worksheet