Books & Videos

Table of Contents

Chapter: Getting Started

What Will I Get Out Of This Course

03m 56s

About The Author

01m 16s

The Working Files Explained

03m 0s

What Is VBA?

05m 8s

Excel 2010 Security Settings And Macro Files

03m 44s

The Developer Ribbon

01m 54s

Chapter: Macros

Recording And Running A Simple Macro

03m 51s

Editing An Existing Macro In The Visual Basic Editor

03m 59s

The New Macro Enabled File Type

02m 22s

Quick Tour Of The Visual Basic Editor

06m 1s

Watch A Macro Write Your VBA

02m 58s

Chapter: Procedures And Functions

What Is A Module?

03m 19s

Creating A Sub Procedure Manually

03m 14s

How To Call A Sub Procedure

02m 50s

Creating A Function Procedure

02m 51s

How To Call A Function

02m 57s

Chapter: Getting Started With VBA Programming

Using Comments Within Your VBA Code

03m 59s

Declaring Variables And Data Types

05m 29s

The Scope Of A Variable

04m 49s

The Static Declaration And Variable Expiry

04m 53s

Constants Instead Of Variables

03m 39s

An Intrinsic Constant

03m 7s

String And Date Types Expanded

06m 5s

VBA Operators

07m 51s


05m 7s

Multi-Dimensional Arrays

03m 33s

Dynamic Arrays

03m 22s

Chapter: Manipulating Excel Objects

Referencing Cells Using The Range Object

05m 28s

The CELLS Property

02m 46s

The OFFSET Property

02m 29s

The VALUE Of Ranges

07m 43s

The TEXT Object Of The RANGE

03m 1s

A Number Of Read Only RANGE Properties

09m 6s

The FONT Property And Colors

08m 20s

Formatting Numeric Values

03m 24s

Add Formulas To Cells Through VBA Code

06m 36s

Common METHODS Of The RANGE Object

11m 46s

Chapter: Working With Excel VBA Functions

What Is A Function?

01m 30s

Built In VBA Date Functions

02m 29s

Text Manipulation With VBA Functions

03m 53s

Determining File Sizes Using FILELEN

02m 34s

Using Worksheet Excel Functions In VBA Code

08m 9s

User Defined Functions

04m 35s

Chapter: Controlling Program Flow And Execution

Using GOTO And Labels

04m 25s

Controlling The Program Flow With IF THEN ELSE

04m 23s

Multiple Criteria Plus Nested IFs

05m 27s

Adding ELSEIF To Speed Up Execution

04m 7s

SELECT CASE As An Alternative To IF

04m 25s


09m 25s

FOR NEXT With A VBA Collection

06m 32s


06m 56s

Chapter: Events

How To Create An Event

06m 57s

WorkBook Events - Open

08m 17s

Workbook Events - Closing And Saving

07m 32s

Workbook Triggers - Activate And Deactivate

05m 12s

Worksheet Triggers - Activate And Deactivate

04m 15s

Other Useful Worksheet Triggers

09m 44s

Using Application Events

12m 6s

Chapter: Debugging And Error Handling

Error Trapping the Easy Way

07m 38s

Make The VBA Ignore Errors

04m 12s

Interact With The User When An Error Occurs

04m 58s

Making Use Of The ERR Object

04m 15s

Debugging Techniques

06m 11s

Using Breakpoints To Help Debug

05m 45s

Setup And Use A Watch

05m 4s

Speeding Up The VBA Tips

12m 50s

Chapter: Interacting With Users Through Forms

Using MSGBOX To Interact With Users

09m 5s

Use INPUTBOX For Accepting Values From Users

07m 19s

Selecting A Range With The INPUT Box

04m 5s

An Introduction To UserForms

04m 6s

Creating A UserForm

04m 22s

Using Command Buttons

05m 17s

Adding Option Buttons In A Frame

05m 13s

Adding The Code That Makes The Form Work

07m 17s

Calling Your UserForm And Validating Content

08m 5s

UserForm Controls - The CheckBox

08m 10s

UserForm Controls - ListBox And/Or Combo Box

10m 10s

Images On UserForms

05m 24s

Labels And Text Boxes

05m 30s

Multiple Tabs On A UserForm

08m 10s

Allowing The User To Highlight A Range

04m 13s

Scrollbar And Spin Controls

08m 18s

Controlling Tab Order And Aligning Controls

08m 48s

Chapter: Running And Storing VBA Code

Trigger A Procedure From The Quick Access Toolbar

05m 5s

Customizing The Ribbons

05m 6s

Adding Buttons To Sheets

03m 51s

Adding A Keyboard Shortcut Trigger

02m 46s

Where To Store Your VBA Code

07m 38s

Adding Code To The PERSONAL File

08m 10s

Chapter: Summary

So What's Next?

02m 27s