Introduction to Microsoft Excel VBA

You will learn how to create and edit macros, and gain a good understanding of VBA code. The course is aimed at new users to VBA. No specific experience with VBA is required but delegates should be proficient in the use of Excel. Some programming experience would be helpful but is not essential.

To create and edit VBA code to automate elements of MS Excel.

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