Microsoft Excel VBA

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.

Course Objectives
By the end of this level you will be able to:

 

• Understand the basics of a Visual Basic Module
   
• Understand how to execute one or more lines of code repetitively
   
• Understand relative and absolute recorded macros, and assign these macros to various objects
   
• Create macros that interact with the user
   
• Create custom functions
   
• Analyze how your code operates and locate the source of errors
   
• Write procedures that test conditions and then run only certain statements based on the results 
   

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.