Microsoft Excel VBA Stage 3

Microsoft Excel VBA Stage 3

Duration:
1 Day
Aims:

This course is designed for those who wish to gain a practical approach to developing VBA solutions and consolidate their existing knowledge.

Objectives:

On completion of this course, attendees will have a more complete understanding of the Visual Basic techniques involved in customising and automating systems in Excel. As well as being able to ask questions on their own programming requirements.

Pre-Requistites

Attendees should have attended our VBA Stage 1 and 2 courses or have equivalent experience. Ideally attendees will have had a chance to put into practice some of the techniques covered in these Foundation courses.

Versions

Courses are delivered in 2007, 2010, 2013, 2016.

What will I learn?
Arrays
  • - Creating and Defining Arrays
  • - Assigning Values to an Array
  • - Filling Arrays Using Loops
  • - Dynamic Arrays
  • - Preserving Array Values
Error Handling & Trapping
  • - Error Handling Code
  • - Trapping Errors with Error Numbers
Event Procedures
  • - Events Associated with Worksheets
  • - Events Associated with a Workbook
Custom User Forms and Form Controls
  • - User-Defined Forms
  • - Adding Controls to a Form
  • - Form Controls Design Tools & Techniques
  • - Form Control Properties
  • - Programming a User Form
  • - Displaying a User Form
  • - Using ActiveX Controls directly on a Worksheet
Filing
  • - Filing commands
  • - The Dir() function
  • - FileSystemObject
Development Techniques
  • - Tips and tricks for developing a VBA solution
Coding Charts
  • - Creating Charts
  • - Sizing and Positioning Charts
  • - Naming Charts
  • - Adding, modifying and deleting Series
  • - Formatting Charts
Coding Pivot Tables
  • - The Pivot Cache and Pivot Table Objects
  • - 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
Related courses
Run this
course at
your offices
Request a quote
which course
Which level do you need?
Take our online skills assessment
Find out more
Speak to a friendly advisor

call

0333 344 6630

or visit our

Online Chat
Trustpilot