Call: 0118 3243000
Shopping CartNo Items In Your Cart
Systematix Training Ltd
Home | Excel | Excel 2003 Visual Basic

Excel 2003 Visual Basic

Public Course Dates

  Date Location
Wed, 17 Mar 2010 Reading
Wed, 14 Apr 2010 Reading
Wed, 26 May 2010 Reading
Wed, 7 Jul 2010 Reading
Wed, 18 Aug 2010 Reading
Wed, 29 Sep 2010 Reading
Wed, 10 Nov 2010 Reading
Wed, 22 Dec 2010 Reading
Wed, 2 Feb 2011 Reading
Wed, 16 Mar 2011 Reading
Wed, 27 Apr 2011 Reading

This course is available as a public course at our Reading training centre.


£550 for 2 days

 Included in the price:
  • Comprehensive Manual
  • Refreshments & Lunch
  • Post Course Support

Course Overview

This two day course leads you through Excel Visual Basic for Applications (VBA) from recording macros to advanced form design. As you progress you will learn how to write object-oriented programs, how to create program control structures and handle errors effectively.

Course Objective

You will learn how to harness the power of the Visual Basic language to control and automate Excel worksheets and applications.

Target student

This course is suitable for advanced users of Microsoft Excel. They may be responsible for large amounts of data handling which needs automating or they may be part of a team and need to learn how to program features and functions to improve data access and usability.

Prerequisites

A thorough knowledge of Excel is required. We recommend completion of Microsoft Office Excel 2003 Level 3 Advanced or equivalent knowledge.

We offer a range of Excel training courses

Getting started with 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
Introduction to Procedural Programming
  • Procedures: Functions and Sub-routines
  • Data Types
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
Control Flow
  • If ...Then....Elseif....Else....Endif
  • Case
  • Do...Loop , While
  • For... Next
  • Exit
  • 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
Procedures, parameters, variables
  • Passing parameters by reference and by value (ByRef or ByVal)
  • Optional and default parameters
  • Passing an array of arguments to a procedure
Debugging
  • Run Time, Design Time, and Break Mode
  • Breaks and Watches
  • Local Window
  • Immediate Window
Error Handling
  • Errors Types
  • On Error GoTo
  • On Error Resume Next
VBA Forms
  • Creating and Using Forms
  • Invoking Forms in VBA Code
  • Using VBA Forms in Worksheet
Arrays * (Any items marked with * will be covered if time allows.)
  • Dynamic arrays
  • Arrays optimization
  • Multidimensional arrays
  • Arrays and objects
Collections *
  • Creating and using collections
  • Adding and remove elements
  • Using index and key
Dealing with files *
  • Reading text files
  • Using CSV files
 
Publisher: Microsoft
Version: 2003
Length: 2 Days
Course-ID: SX612A
Printer Friendly Version
Download Outline As PDF
Request A Quote Ask Us A Question

Related Courses

The trainer took the trouble to find out what we required before the course and adapted the material to our needs very well

- Gillette

Microsoft Registered Partner
BSI ISO 9000