WWP key in developing people
About WWP
Professional Development
Project Management
Apprenticeships
Customer Portal
Duration: 1 day(s)
Course Code: XLL7
Add to Favourites
Dates
London Centre 20th Jun 2012 book
London Centre 24th Aug 2012 book
London Centre 17th Oct 2012 book
London Centre 14th Dec 2012 book
Dedicated Course Request
Price:
£345.00+VAT
print this page
email this page

Excel Level 7
Advanced VBA Programming

Aims

This course is aimed at people who already have a very good knowledge of Excel VBA and who wish to improve on this to create more effective, interactive and user friendly procedures, and extend the reach of their VBA code into areas outside of the Excel application.

Prerequisites

Students who wish to attend this course need to have significant experience and ability at understanding and using Excel advanced functionality and have attended the Microsoft Excel Level 5 and Level 6 courses.

Objectives

  • Write code that prevents or diminishes the chance of errors and failures occurring when a macro is run.
  • Write procedures that automatically run when an action is initiated either by the user or by the system.
  • Enable interaction between a user and a procedure using a custom user form (dialog box) and ActiveX Worksheet controls.
  • Use VBA to create, structure and format charts.
  • Use VBA to create, structure and update Pivot Tables.
  • Produce code that interacts with and facilitates the use of other Microsoft Office application objects.

Course Content

Error Handling & Trapping

  • Evaluating Data Using IF Statements
  • Error Handling Code
  • Trapping Errors with Error Numbers
  • The TypeName Function


Event Procedures

  • Events Associated with Worksheets
  • Events Associated with a Workbook
  • Timed Events


Custom User Forms and Form Controls

  • User-Defined Forms
  • Adding Controls to a Form
  • Form Controls Design Tools and Techniques
  • Form Control Properties
  • Programming a User Form
  • Displaying a User Form
  • Using ActiveX Controls directly on a Worksheet


 

 Working with Charts
  • Creating Charts
  • Sizing and Positioning Charts    
  • Naming Charts
  • Adding a Series to a Chart
  • Deleting Series from a Chart
  • Formatting Charts

Working with Pivot Tables
  • The Pivot Table Object
  • Creating a Pivot Table
  • Naming Pivot Tables
  • Manipulating Pivot Table Fields
  • Refreshing Pivot Tables

Interacting with Other Office Applications
  • Communicating with Word and PowerPoint using Excel VBA

Click to expand...

Perfect Partners

Other courses which naturally complement this course include:

  • Excel Level 4
  • Access Advanced
  • Access VBA Programming