Register | Login
 Course Description Minimize

 Excel VBA - Excel Visual Basic Programming Training Course 2003 - 2007

Visual Basic for Application (VBA) is part of the Microsoft Visual Basic family that is used to extend the already powerful capabilities of applications such as Microsoft Excel. VBA is an embeddable programming environment designed to enable developers to build custom solutions using the power of Microsoft Visual Basic. Developers using applications that host VBA can automate repetitive tasks and extend the application functions, shortening the development cycle of custom business solutions.

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, or those wanting to improve and consolidate their programming skills in the context of Microsoft Excel. The training course begins with 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. Consequently, even though the course materials are based on MS Excel 2003, the VBA concepts, principles and examples can also be applied to MS Excel 2007.

Course exercise files can be downloaded by subscribed users who want follow along each tutorials.

Note: Monitor resolution needs to be set to at least 1024 X 768 to view the video tutorials.
  

Excel vba training
 Training Courses
  

Please see below the online Excel VBA - Excel Visual Basic training course outline. Access to all tutorials will be activated immediately when you subscribe. Subscribe now or try a sample tutorial below

sample tutorial:  Declaring & Using Arrays  

 
 Training Course Outline
Introduction 


Getting Started 
What is Excel VBA 
VBA editor interface I 
VBA editor interface II 
VBA code writing 
VBA help 

Using Macro for Excel Programming
Recording a macro 
Running a macro 
Editing a macro 
Macro virus protection 
Creating a macro menu & button 

Excel VBA Programming Fundamentals
Objects & object collections 
Methods & properties 
Events & event handler 
VBA components 

Variables 
Variables & data types 
Defining variables 
Static variables 
Constants 
Option explicit 
Scope 

Procedures & Modules 
Exploring procedures 
Exploring modules 
Using arguments 
Function procedures 
Improving code readability 

Object Oriented Programming 
Creating class modules & objects I 
Creating class modules & objects II 
Using the Object Browser 
Using system classes 

Referencing Excel Objects 
Referencing workbooks 
Referencing worksheets 
Referencing cells 
Referencing multiple cell ranges 
Working with 3-D range 
Referencing rows & columns 
The offset property 

Creating and Managing Arrays 
Understanding arrays 
Declare an array 
Manage dynamic array 
Create multi-dimensional arrays 

Control Structures - Decision Making 
If statements 
Select Case statements 
The Choose function 
The With statement 

Control Structures - Looping 
For ... Next statement 
For Each ... Next statement 
Do While statement 
Do Until statement 
Do Loop While/Until statements 

Interacting with Users 
Creating a user form 
Form controls 
The Message Box function 
The InputBox function 

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 

Managing VBA Codes 
Saving & storing codes 
Using codes from external sources 
Using codes from other projects 
Password protect your codes 
  
Copyright 2006-2008 by Tayop Technologies & Training