MS Excel - VBA
1 Day Training Course / £350 plus VAT
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
|