Provided by: WWP Training Ltd

Microsoft Excel Level 6 Intermediate VBA Programming

Workplace Skills

WWP Training Ltd
Aims
This course is aimed at people who want to explore further the VBA language and write VBA code so that future maintenance tasks can be carried out with the minimum of effort.
Prerequisites
Students who wish to attend this course must have a good knowledge of Excel and have attended the Microsoft Excel Level 5 Introduction to VBA course or have good personal experience at writing basic VBA code.
This is primarily ilt training
Course Level:basic
Duration:1 days
Training Presented in:English
Training Provided by WWP Training Ltd
Microsoft Excel Level 6 Intermediate VBA Programming
Objectives
On completion of this course delegates will be able to:
Refer to range objects using different types of code
Understand and effectively use variables and arrays
Create custom functions
Test their code using VB Editor tools
Deal with potential errors in the execution of their sub procedures with error handling code
Make their code more accessible by saving it as an Add-In
Improve the interactivity of their code with custom user forms
Course Content
Range Objects
Referring to Ranges
Collections
The Current Region Property
The Offset & Resize Functions
Variables & Constants
Declaring Variables
Scope & Visibility
Constants
Arrays
User Defined Functions
Using Excel Functions in VBA
VBA Functions
Function Procedures
Add-In Applications
Creating an Add-in
Installing an Add-In
Editing and Removing an Add-In
Debugging & Error Trapping
Types of Error & Debugging
Stepping a Procedure
Break Mode
Error Handling
User Forms & Built-in Dialog Boxes
Using Built-In Excel Dialog Boxes
Designing a Userform
Setting Control Properties
Adding Form Events
Displaying a Custom Userform
About The Training Provider: WWP Training Ltd
WWP Training Ltd - WWP Training Limited is a leading Learning and Development organisation that offers an extensive portfolio of training courses within the areas of Professional Development, IT Skills and Project Management. Our aim as a trusted training partner is to provide flexible and memorable training solutions that match our customers needs regardless of their level of experience or expertise. WWP...
Want to market your excel training?
Custom Search
tcw11-v473M-04/25/15-14:11:13-()[A]-[B]-[B] -01:57:59