Need a training session for just you, or perhaps your whole team?
Book a course with an expert trainer at a time and location that suits you. Courses available online, at your offices, or at our London training centre.
Need something a little different from our standard course outline?
We can focus any of our courses on you or your team's needs. Find out how we can help you meet your goals with a tailored course.
Getting Started
• Displaying the Developer Tab
• Recording and running a Macro
• Macro-Enabled Workbooks
• Using the Visual Basic Editor
• The Development Environment
• Understanding Macro Security
Working with Procedures and Functions
• Understanding Modules
• Understanding Procedures
• Calling Procedures
• Creating a Function Procedure
• Working with the Code Editor
Understanding Objects
• Objects and Collections
• Working with Properties
• Using the With Statement
• Creating an Event Procedure
Using Expressions, Variables, and Intrinsic Functions
• Understanding Expressions and Statements
• Declaring Variables
• Understanding Data Types
• Using Intrinsic Functions
• Understanding Constants
• Declaring and using Object Variables
Controlling Program Execution
• Control-of-Flow Structures
• Working with Boolean Expressions
• Different types of Control-of-Flow structures
• Guidelines for use of Control-of-Flow Structures
Working with Forms and Controls
• Working with UserForm Properties, Events and Methods
• Working with different Controls
• SettingControl Appearance
• Populating a Control
• Adding Code to Controls
• Launching a Form in Code
Handling Errors
• Understanding Error Handling
• Writing an Error-Handling Routine
• Working with Inline Error Handling
Questions and answers
"Very Knowledgable and friendly/flexible"