Excel 2003 - Macros and Introduction to VBA
Categories: Microsoft Excel
Excel 2003 - Macros and Introduction to VBA (1 day course)

Course objectives:
By the end of this course you should be confident to create procedures for controlling the behaviour and appearance of an Excel spreadsheet, create procedures that run in response to specific events, create user forms to accept or display data, validate the data entry in user forms, and debug and handle errors in code.

Prerequisites:
You should be an advanced user of Excel and ideally have attended Intermediate and Advanced level courses before this course.

Course contents
VBA terminology

Start the VBA editor

Work with:

- Object properties

- Methods

Attach code to events and buttons

Use the object browser

Programming basics

Variables and data types

Expressions

Manipulating data

Getting input from the user in Input and Message boxes

Variables and scope

Procedures

Calling one procedure from another

Using loops

Do / while

For / Next

If...Else..End..If

Select Case...Case 1,2,3, Else...End Else

USER FORMS

Creating a dialog box (user form)

Displaying a dialog box

Using text boxes and labels

Using command buttons

Using combo and list boxes

Error handling

Identifying compile-time, run-time and logical errors in code

Use the debugging tools

Write error handling code to trap errors




 
Tools
 
Key Details
Duration1 day
 
£375
per delegate