Course Description

A two day course designed to teach experienced users of Excel how to automate spreadsheets. As well as utility macros (Sorting, Printing, Graphing etc.), user defined functions, user input, arrays and event driven macros are also covered.

Course Pre-requisites

Experienced Excel user familiar with Excel at an advanced level.

Course Outline

Day 1
- Recording and Debugging Macros
- VBA Projects, Modules and Procedures: structure and coding
- Running macros: Keys, Buttons, Events and Menus
- User Defined Functions
- Variables and Constants: Declaration, assignment & scope
- Objects & Collections: Properties, Methods & Object Browser
- Debugging Macros, Breaks, Watches & Run Time errors
- Handling User input and showing messages
- Flow of Control commands (IF, SELECT, FOR, DO, WHILE etc.)
Day 2
- Arrays in Excel VBA
- OLE Automation within and from Excel
- Calling Excel Dialogue boxes
- Creating your own User Forms
- User Form controls and properties
- Writing code behind User Forms
- Creating and editing Command Bars and Toolbars
- Running Macros from Workbook and Worksheet events

Course outline in pdf format



Length:   2 days

Cost:   £414 per person (£345 + VAT)

Trainer:   Stuart Brown



Register your interest

If you are interested in this course please complete our short form and we will keep you informed when other dates and locations are available.

Further information:

Other courses in which you may be interested: Excel VBA (1 day)   If there is a course you would like us to run then please suggest a course   Don't forget to visit our News and Events pages