VBA courses for all versions of Excel - VBA for Excel 2019, 365, 2016, 2013, 2010 and other versions. Delivered in Dundee, Aberdeen, Edinburgh, Stirling, Angus, Fife, Glasgow, London, Perth and most locations across the country. Contact us for further details.
This content has been designed for a one-day classroom course. On course completion, students will be able to:
The course is designed to give experienced Excel users proficiency in creating procedures that run in response to specific events, working with control structures, developing user forms to accept or display data, validating the data entry in user forms, and debugging and handling errors in code. The course is an effective combination of tuition by an experienced instructor together with hands-on exercises to give the trainee the experience of writing code and applying VBA.
Visual Basic Editor
Visual Basic for
Applications
Object programming
The Object Browser
Programming basics
Data basics
Scope of variables
Scope of procedures
Control
structures
Decision structures
Loop structures
Custom dialog boxes
User forms
Events
Debugging and error handling
Errors
Debugging
Error handling