Excel 2003 - Macros and Introduction to VBA
Need course dates or locations to suit you? CLICK HERE TO SEND ENQUIRY...  
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




 
Need course dates or locations to suit you? CLICK HERE TO SEND ENQUIRY...  
My Location
Results for location are highlighted in the table below. Click here to remove highlight
The course either has new dates in data loading, or is only run as a dedicated or In Company course.
Tools
 
Key Details
Duration1 day
 
£375
per delegate
 
 
Bookings Helpline: 01933 233884 (Monday to Thursday - 8:00am to 5:30pm and Friday 8:00am to 5:00pm).