Excel VBA in One Day

• Computer literacy
• Knowledge of any operating system

This live instructor-led training (onsite or remote) will guide you through the most important elements of  Excel VBA. A combination of comprehensively prepared training materials and the expertise of the instructor will demonstrate the power of task automation using VBA.

Format of the Course

• Interactive lecture and discussion.
• Hands-on implementation in a live-lab environment.

Course Customization Options

• To request a customized training, please contact us.

The outline below is a suggested list of topics to be discuessed during the course of the training. The final curriculum may differ from the presented topics below, depending on the experience, expectations and needs of the participants.

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

Events Handling in VBA

VBA Forms

• Creating and Using Forms
• Invoking Forms in VBA Code
• Using VBA Forms in Worksheet