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

Learn Excel Visual Basic for Applications (VBA) in this two day course, which covers recording macros through advanced form design. This course will show you how to write object-oriented programs, how to create program control structures and how to handle errors effectively.

Course Objective

Use the power of the Visual Basic language to harness and to automate Excel worksheets and applications. Learn how to make Excel do the most for your business or organization.

Target student

Advanced users of Microsoft Excel will receive the most benefit from this course. The user who works with large amounts of data in need of automation or who must collaborate with others in a team may have need to learn how to program features and functions to increase data access and functionality.

Prerequisites

Thorough knowledge of Excel is essential for success in this course. The Systematix course Microsoft Office Excel 2003: Level 3 Advanced or equivalent knowledge or experience is highly recommended.

We offer a range of Excel training courses

Getting started with Macros
  • Assigning Macros to Toolbar, Buttons, Shortcut key
  • Recording and Modifying Macros
Visual Basic for Applications Environment
  • Component Management
  • Shortcuts
  • Visual Basic Editor and its options
Introduction to Procedural Programming
  • Data Types
  • Procedures: Functions and Sub-routines
Excel Model Object
  • Application Object
  • Cells Collection
  • Events Handling in VBA
  • Range Collection
  • Screen Updating and Optimizing
  • Selection Object
  • ThisWorkbook, ActiveWorkbook, ActiveCell, ....
  • Timer and Time Measuring
  • Using Status Bar
  • Workbook Object and Workbooks Collection
  • Worksheet Object and Worksheets Collection
Control Flow
  • Case
  • Do...Loop , While
  • Exit
  • For... Next
  • Getting and Printing Data from Users (InputBox, MsgBox)
  • If ...Then....Elseif....Else....Endif
  • VBA and Sheet Data Exchange (Cells, Range Methods)
Variable Declaration
  • Creating Worksheet Functions
  • Locking Project for Viewing
  • Modules Options
  • Objects, Classes, Methods and Properties
  • Operators and Their Priorities
  • Scope and LifeTime of Variables and Objects
Procedures, parameters, variables
  • Optional and default parameters
  • Passing an array of arguments to a procedure
  • Passing parameters by reference and by value (ByRef or ByVal)
Debugging
  • Breaks and Watches
  • Immediate Window
  • Local Window
  • Run Time, Design Time, and Break Mode
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.)
  • Arrays and objects
  • Arrays optimization
  • Dynamic arrays
  • Multidimensional arrays
Collections *
  • Adding and remove elements
  • Creating and using collections
  • 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

Excellent course, most topics were useful and the others were interesting and will be good to know about even if they don't affect my job personally

- IRI

Microsoft Registered Partner
BSI ISO 9000