Excel VBA Training
This Excel VBA training course delves into the advanced features of Microsoft Excel. Using Visual Basic (VBA) to program and automate tasks enables you to harness the power that is behind Microsoft Excel. The techniques covered are applicable to both older versions of Excel and Excel 2007 as Excel VBA remains the same in all Excel versions.
Please see below the tutorial lessons and topics covered in this training course. Click on the sample tutorial below to see for yourself the quality of our training. Join us and get instant access to all training courses on our site.
Note: Monitor resolution needs to be set to at least 1024 X 768 to view the video tutorials.
Register Now and Activate This Excel VBA Training Course Instantly
Excel VBA Training Course Online
Free sample tutorial: VBA data types
Introduction
Chapter 1 - Getting Started With Excel VBA
What is Excel VBA?
VBA editor I
VBA editor II
Writing VBA code
VBA help
Chapter 2 - Using Macros in Excel
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 - Excel VBA 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 - The Object Oriented Programming Concept
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 - 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
