Course Outline
Getting Started
Introducing Visual Basic for Applications
Displaying the Developer Tab in the Ribbon
Recording a Macro
Saving a Macro-Enabled Workbook
Running a Macro
Editing a Macro in the Visual Basic Editor
Understanding the Development Environment
Using Visual Basic Help
Closing the Visual Basic Editor
Understanding Macro Security
Working with Procedures and Functions
Understanding Modules
Creating a Standard Module
Understanding Procedures
Creating a Sub Procedure
Calling Procedures
Using the Immediate Window to Call Procedures
Creating a Function Procedure
Naming Procedures
Working with the Code Editor
Understanding Objects
Navigating the Excel Object Hierarchy
Understanding Collections
Using the Object Browser
Working with Properties
Course Outline :: Macro – Basic::
Using the With Statement
Working with Methods
Creating an Event Procedure
Programme scope, delivery arrangements and suitability are confirmed during enquiry.