Microsoft Excel VBA Introduction

Microsoft Excel VBA

Introduction to Microsoft Excel VBA
You will learn how to create and edit macros, and gain a good understanding of VBA code.

Content

• Section 1 Introduction - Recording Macro's - Running a Macro - Absolute & relative References
• Section 2 Assigning Macro's - Assigning to a Button - Assigning to the Toolbar
• Section 3 Editing Macro's - Editing a Macro - The VBA Environment
• Section 4 An Introduction to VBA - An Introduction to Objects, Properties, Methods and Events - An Introduction to VBA Procedures, Functions and Classes - An Introduction to Modules, Forms and Event Procedures - The VBA Object Browser
• Section 5 Programming in VBA - Creating a simple procedure - Using VBA Functions - VBA Branching Commands - Passing Arguments to functions & procedures - VBA Control Structures - Creating & Using Variables - Creating & Using Constants - Creating & Using Static Arrays - Creating & Using Dynamic Arrays
• Section 6 The Range Object - The Cells property - The Range property - Flexible Ranges
• Section 7 Workbook & Worksheets - Activating Workbooks - Activating Worksheets - This workbook - Workbook & Worksheet Events
• Section 8 Custom & Built in Forms - Built In Dialogue Boxes - Creating User - defined Forms - Using User Defined Forms - User defined Toolbars & menus
• Section 9 Handling Errors in VBA - Using the VBA Debugger - Trapping Errors - Using the ERR Object

Course Includes: Lunch/refreshments and course materials.