Add EXL5 to my courses Excel VBA Level 3 (2 days - £550, plus VAT)

Microsoft Excel VBA Training Courses in London

Designed for experienced Excel VBA developers who are familiar with working with the Excel object model.

Developing applications

Types of applications
Types of end-user
Analysing end-user needs
Planning an application
Planning the user interface

Working with events

Overview of event types
Event-handler procedures
Workbook events
Worksheet events
Chart events
UserForm events
Activate event
Save events
Change events
Focus events
Click events

Pivot tables

Pivot table code overview
Creating a pivot table
PivotField object
PivotItems collection
Modifying a pivot table
Using external data

Charts and Sparklines

About programming charts
Working with embedded charts Working with independent charts
Controlling chart formatting
Assigning a range to a chart
Positioning a chart
Making a chart active/inactive
Editing data series
Controlling chart labels
Creating sparklines
Handling hidden columns
Setting sparkline attributes

File Manipulation

Opening a text file
Writing a text file
Importing data from a text file
Searching for text in files
Verifying if a file exists
Listing all files in a given folder

Class modules

Class modules defined
When to use class modules
Creating a class module
Property procedures
Method procedures


Back to top

Macresource Business SoftWare Training Courses
Access training | Excel training | Access VBA training | Excel VBA training
Project training | Visio training | Outlook training | Windows XP training
FileMaker training | MySQL training | PowerPoint training | Word training
Free computer software tutorialsLondon computer training room hire