MS VISUAL BASIC FOR EXCEL (VBA)
Introduction to Microsoft
Excel Macros and VBA
The Microsoft Excel Macro Recorder
Recording a Macro
A Practical Example
Playing a Macro
Absolute and Relative Recording
Deciding between Relative VS Absolute Referencing
Making Your Macros Accessible
Adding Buttons to your Worksheet
Adding Controls from the Forms Toolbar
Adding Controls from the Control Toolbox Toolbar
Custom Toolbars
A Peak into the world of VBA
Programming
The Visual Basic Editor
Code Procedures and Modules
The Project Explorer
The Properties Window
Updating a Recorded Macro
Creating User Defined Functions
Programming Microsoft Excel with VBA and more UDF's
Direct Reference to Ranges
What UDFs cannot do and some other tips
The Microsoft Excel Object Model
Microsoft Excel Objects
Microsoft Excel Collections
Microsoft Excel VBA Object Properties
Microsoft Excel VBA Object Methods
The Microsoft Excel VBA Object Browser
Experimenting in the Immediate Window
Concepts in VBA
Getting to grips with objects and their Properties and Methods.
Understanding Procedures and Modules
An introduction to events and event handling.
Objects
Treatment of Objects in general
An introduction to naming conventions
How Properties & Methods are accessed and used.
Objects commonly found in Microsoft applications
Objects specific to Microsoft Excel
Variables & Constants
A general introduction to storage using Variables and Constants.
When and how to declare, use and name them
Control Structures
Determining the flow of a program.
Writing self-contained, re-usable Procedures
Controls
Control types commonly found in Microsoft applications
How to use and create them.
Procedures
Use of Procedures in VBA
Procedures & Functions
Calling Procedures from other Procedures
Passing data between Procedures
Using standard Functions
Use of Named Arguments
An Introduction to the creation and use of custom functions
Automatic Procedures in Excel
Debugging & Error Handling
Types of errors and how to handle them
Investigating problems using the Debug Window.