Home > Training > Microsoft Office 2002 (XP)

Excel 2002 (XP) Programming using VBA

Duration
2 days

Course Objectives
Visual Basic for Applications can extend the power of Excel 2002 into a new dimension. This course will teach you how to harness the power of VBA to create completely tailored applications.

In addition to learning the structure and syntax of VBA, delegates will benefit from advice and tips on good application design.

Outline
Macros
Overview of Macros
Recording Macros
Macro Statements
Macro Execution
Common Macro Errors & Tips
Assigning Macros to Buttons & Menus
Macro Storage

Macro Types
Subroutine Macros
Function Macros
Event Macros

Visual Basic
Objects, Properties, Methods & Comments
Syntax
Object Browser
Property Statements
Working with Worksheets
Working with Cells
Cell Addressing
Variable Cell Ranges

VB Statement Types
Action
Assignment
Control
Input/Output
Customising
Comment

Control Structures
Variables
Assigning Values to Variables
Constants
If...Then...Else
Select Case
Do While Loops
For...Next & For Each...Next
InputBox
MsgBox
Running Other Macros

Controls and Forms
Predefined Forms
Custom Forms
Form Control Features
Form Code

Error Handling
Error Types
Common Problems and Solutions

Testing and Debugging
Debug Facilities
Breakpoints
Locals and Watch Windows
Immediate Window
Debugging Tips

Performance Tips

Add-in Applications & Menu Editor

Assumed Knowledge
Delegates should be familiar with Excel 2002, using it regularly on a day-to-day basis, and be thoroughly familiar with range naming in Excel.

Course Times
10:00am to 5:00pm

Comprehensive course manual included.
Refreshments and lunch are provided on all courses at the Information Horizons Training Centre.

Back to the top