Microsoft Excel VBA Training Courses
Advanced VBA Microsoft Excel Training Course Information
1 Day Course
*Book 2 or more delegates and receive significant discounts. Click here for information
Scheduled public courses are held at Preston, Liverpool, Manchester & London.
Closed tailored courses are available on your site if requested.
This course is run on demand. Please call 0845 402 2781 for details.
Introduction
This one day course is designed for delegates wishing to automate common worksheet operations, to convert worksheets into forms and to understand Excel VBA code.
On completion of this course delegates will be able to design macros, to edit VBA code and to build procedures which interact with the users.
Course Objectives
-
Record macros to automate tasks
-
Write control structures
-
Create custom functions
-
Build user forms
-
Build procedures using variables
Pre-requisites
Delegates should have already attended an Excel Advanced course or be able to demonstrate equivalent knowledge.
Course Content
- Introduction to Excel VBA
- Recording and running procedures
- Viewing and editing procedures
- Working with Visual Basic Code
- Understanding Objects, Properties and Collections
- Simple user input
- Control and looping
- Debugging
- Error handling
- Customising the User Interface