| training courses |
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.
Register and Start Learning Today
Visual Basic for Excel (Excel VBA) Training Course
Click the links below to view the video tutorials
Chapter 1 - Getting Started
What is Excel VBA
VBA editor interface I
VBA editor interface II
VBA code writing
VBA help
Chapter 2 - Using Macro for Excel Programming
Recording a macro
Running a macro
Editing a macro
Macro virus protection
Creating a macro menu & button
Chapter 3 - Excel VBA Programming Fundamentals
Objects & object collections
Methods & properties
Events & event handler
VBA components
Chapter 4 - Variables
Variables & data types
Defining variables
Static variables
Constants
Option explicit
Scope
Chapter 5 - Procedures & Modules
Exploring procedures
Exploring modules
Using arguments
Function procedures
Improving code readability
Chapter 6 - Object Oriented Programming
Creating class modules & objects I
Creating class modules & objects II
Using the Object Browser
Using system classes
Chapter 7 - Referencing Excel Objects
Referencing workbooks
Referencing worksheets
Referencing cells
Referencing multiple cell ranges
Working with 3-D range
Referencing rows & columns
The offset property
Chapter 8 - Creating and Managing Arrays
Understanding arrays
Declare an array
Manage dynamic array
Create multi-dimensional arrays
Chapter 9 - Control Structures - Decision Making
If statements
Select Case statements
The Choose function
The With statement
Chapter 10- Control Structures - Looping
For ... Next statement
For Each ... Next statement
Do While statement
Do Until statement
Do Loop While/Until statements
Chapter 11- Interacting with Users
Creating a user form
Form properties
Form controls
The Message Box function
The InputBox function
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
Chapter 13- Managing VBA Codes
Saving & storing codes
Using codes from external sources
Using codes from other projects
Password protect your codes
