training courses

Excel VBA Training Course Online

Excel VBA trainingFree 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

Introduction

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

 
منتدى شات صوتي منتدى سعودي دردشة صوتية شات سعودي شات قطر شات صوتي كام شات سعودي جلسات طرب  شات الكويت