Excel VBA Training Course Online
Free sample lesson: Declaring and using arrays
Visual Basic for Application (VBA) is part of the Microsoft Visual Basic family that is used to extend the capabilities of applications such as Microsoft Excel. This online Excel VBA programming training course contains a series of video-based training tutorials designed for users who want to learn the essential skills of VBA programming and macros, or those wanting to improve and consolidate their programming skills in the context of Microsoft Excel. The training course begins with the basics of VBA and quickly advances to cover the more advanced features, including how to reference Excel objects, Object Oriented Programming, error handling, modules and much more.
Although there are significant changes in MS Excel 2007, VBA remains the same whether you use Excel 2003 or Excel 2007. So even though the course materials are based on MS Excel 2003, the VBA concepts, principles and examples also apply to MS Excel 2007.
Course exercise files can be downloaded by subscribed users who want follow along each tutorials. Access to all tutorials will be activated immediately when you subscribe by clicking the button below.
Note: Monitor resolution needs to be set to at least 1024 X 768 to view the video tutorials.
Visual Basic for Excel (Excel VBA) Training Course
Click the links below to view the video tutorials
Chapter 7 - Referencing Excel Objects
Referencing multiple cell ranges
Working with 3-D range
Referencing rows & columns
The offset property
Chapter 12- Error Handling and Debugging
Errors & error handling I
Errors & error handling II
The Resume statement
Getting error information
Debugging & navigating code
Working in break mode
The Immediate window
The Locals window
The Watch window