The ideal introduction to the world of VBA programming in either Word, Excel or Access

Is it right for me?

If you already have a good understanding of Word, Excel or Access and its basic functionality, this is an ideal opportunity to learn how to develop even more intelligent and interactive features, by harnessing the power of VBA programming.

What is it about?

This course will introduce the most useful and easy-to-replicate elements in the VBA coding language, and will demonstrate how to blend this with Word, Excel or Access, to create automated tasks, impressive user interfaces and automated work flows.

What will I learn?

This is a highly interactive course, to which delegates are invited to bring their own real-life work issues to use as live examples. From a general overview of the menus and toolbars in Visual Basic Editor, to programming structures, coding protocol and working with forms, this is an extremely thorough introduction to Visual Basic for Applications with the participants ultimately driving the content at a pace and volume that is right for them.

What will it cover?

• Introduction
• Visual Basic Editor
• Overview of Menus and Toolbars
• Project Explorer
• Local, Immediate and Watch Windows
• Object explorer
• Programming Basics
• Objects, Properties and Methods
• Comments
• Code Layout
• Location of Code
• Programming Structures
• Sub and Function Statements
• Decision Code
• Select Case Statement
• Loops
• With Statement
• Msgbox and Inputbox
• Variables
• Working With Forms
• Accessing Data
• Error Handling
• Development Process