Excel VBA
Three Day Course

Course Overview

This course is designed to teach delegates how to develop applications to meet the changes that are required in systems development. This is achieved by combining the Visual Basic for Applications Programming System, Applications Edition with Microsoft Excel, delegates can therefore build a greater functionality into custom applications.

Delegates Requirements

It is essential that delegates have attended an Excel Advanced Course or gained similar knowledge in their work environment.

Who Should Attend

Delegates who need to learn how to create sophisticated applications with features such as custom dialogue boxes and menus. Use Excel to develop applications for data presentation, Create structured macros and identify macro code, Control other programmes in Microsoft Office, Access external data for analysis in Microsoft Excel.

Course Outline

Introduction to Microsoft Solutions Development

Introduction to Visual Basic for Applications

Advantages of Microsoft Excel as a Development Platform
Resources for Microsoft Excel Development
Exploring an Application Written in Visual Basic for Applications

Recording, Editing and Running Macros

Terminology
Using the Macro Reader
Working with Macros Assigning Macros Within the Environment
Editing Code
Creating Macros

Working with Visual Basic Code

Terminology
Variables
Sub Procedures
Function Procedures
Scope
Using the Visual Basic Toolbar
Tips for Browsing Lengthy Code Using Code From Help

Simple User Input, Control and Looping

User Input
Conditional Branching
Looping
Writing Looping and Conditional Code

Understanding Objects, Properties and Collections

Objects
Properties Overview
Methods Overview
Object Variables
Collections
Common Collection Properties and Methods
Object Browser
Working With Objects

Working With Common Microsoft Excel Objects

The Range Object
Referencing Cells, Rows, Columns and Ranges
Working With Unknown Ranges Using Offset,
Resize and Current Region Formula, Value and Formula Array.
Using For Each With a Range of Cells
Working With Charts
Opening and Closing Workbooks
Working With Common Objects

Debugging and Error Handling

Identifying Types of Errors
Using the Debugging Tools in Visual Basic for Applications
Running Portions of Code
Monitoring Data and Error Handling
Debugging Visual Basic Code

Controls and Dialog Boxes

Introduction to Controls
Using Controls on Worksheets
Working With Custom Dialog Controls
Creating a Custom Dialog Box

Creating a Custom User Interface

Terminology
Working With Toolbars Manually
Working With Toolbars Programmatically
Working With Menus Manually
Working With Menus Programmatically
Adding Help and Statusbar Messages
Adding Custom Menus and Toolbars to Microsoft Excel

TO BOOK A COURSE
Telephone 01794 521449