Visual Basic for Excel Microsoft VBA Excel Tutorial 

Working Files - Download These First

What Will I Get Out Of This Course

The Excel Working Files Explained

How to obtain your Certificate of Completion for this Infinite Skills course.

What Is VBA For Excel?

Excel 2010 Security Settings And Macro Files

The Developer Ribbon

Macros

Recording And Running A Simple Macro

Editing An Existing Macro In The Visual Basic Editor

The New Macro Enabled File Type

Quick Tour Of The Excel Visual Basic Editor

Watch A Macro Write Your VBA

Procedures And Functions

What Is A Module?

Creating A Sub Procedure Manually

How To Call A Sub Procedure

Creating A Function Procedure

How To Call A Function

Getting Started With VBA Programming

Using Comments Within Your VBA Code

Declaring Variables And Data Types

The Scope Of A Variable

The Static Declaration And Variable Expiry

Constants Instead Of Variables

An Intrinsic Constant

String And Date Types Expanded

Excel VBA Operators

Arrays

Multi-Dimensional Arrays

Dynamic Arrays

Manipulating Excel Objects

Referencing Cells Using The Range Object

The CELLS Property

The OFFSET Property

The VALUE Of Ranges

The TEXT Object Of The RANGE

A Number Of Read Only RANGE Properties

The FONT Property And Colors

Formatting Numeric Values

Add Formulas To Cells Through VBA Code

Common METHODS Of The RANGE Object

Working With Excel VBA Functions

What Is A Function?

Built In VBA Date Functions

Text Manipulation With VBA Functions

Determining File Sizes Using FILELEN

Using Worksheet Excel Functions In VBA Code

User Defined Functions In Excel

Controlling Program Flow And Execution

Using GOTO And Labels

Controlling The Program Flow With IF THEN ELSE

Multiple Criteria Plus Nested IFs

Adding ELSEIF To Speed Up Execution

SELECT CASE As An Alternative To IF

The FOR NEXT Loop

FOR NEXT With A VBA Collection

DO WHILE Loop

Events

How To Create An Event

WorkBook Events - Open

Workbook Events - Closing And Saving

Workbook Triggers - Activate And Deactivate

Worksheet Triggers - Activate And Deactivate

Other Useful Worksheet Triggers

Using Application Events

Debugging And Error Handling

Error Trapping the Easy Way

Make The VBA Ignore Errors

Interact With The User When An Error Occurs

Making Use Of The ERR Object

Debugging Techniques

Using Breakpoints To Help Debug

Setup And Use A Watch

Speeding Up The VBA Tips

Interacting With Users Through Forms

Using MSGBOX To Interact With Users

Use INPUTBOX For Accepting Values From Users

Selecting A Range With The INPUT Box

An Introduction To UserForms

Creating A UserForm

Using Command Buttons In Excel

Adding Option Buttons In A Frame

Adding The Code That Makes The Form Work

Calling Your UserForm And Validating Content

UserForm Controls - The CheckBox

UserForm Controls - ListBox And/Or Combo Box

Images On UserForms

Labels And Text Boxes

Multiple Tabs On A UserForm

Allowing The User To Highlight A Range

Scrollbar And Spin Controls

Controlling Tab Order And Aligning Controls

Running And Storing VBA Code

Trigger A Procedure From The Quick Access Toolbar

Customizing The Ribbons

Adding Buttons To Sheets

Adding A Keyboard Shortcut Trigger

Where To Store Your VBA Code

Adding Code To The PERSONAL File

Summary

So What Next?