Duration
1 day
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
Using the With Statement Working with Methods Creating an Event Procedure
Programme scope, delivery arrangements and suitability are confirmed during enquiry.