---

Introduction
Course Overview (04:11) T

Macros and VBA - A Demonstration (12:07) T

Using Excel Online Help (05:10) T

Using Visual Basic Online Help (04:47) T

Locating Information Across Help Files (07:54) T

Macros - the Quick Solution
Overview (03:08) T

Macro Virus Protection (01:54) T

Recording a Macro (08:34) T

Running a Macro (06:06) T

Reviewing and Organizing Recorded Code (08:16) T

Changing a Macros Functionality (02:19) T

Controlling Access to Macros (10:07) T

Simplifying Access to Macros (03:53) T

Summary (01:39) T

The VBA Programming Language
Overview (02:32) T

Objects and Collections (04:33) T

Methods; Properties and Events (02:56) T

Procedures and Functions (07:35) T

Executable Statements (03:21) T

Assignment Statements (04:06) T

Declaration Statements (05:27) T

Variables and Constants (04:00) T

Scope (04:44) T

Lifetime and Data Type (09:26) T

Summary (00:56) T

The VBA Development Environment
Overview (02:02)
Windows (08:42)
Command Bars (02:22)
The Code Window (05:25)
Margin Indicator Bar (02:52)
Code Interpretation (05:26)
Type and Status Formatting (04:36)
Entering Keywords (05:25)
Syntax Assistance (05:10)
The Project Explorer (07:28)
The PropertiesWindow (03:10)
The Object Browser (10:47)
Using the Object Browser (05:51)
Summary (00:58)
Development and Troubleshooting
Overview (02:00)
Running Code and Debug Printing (05:57)
Step Into, Break Mode and the Call Stack (05:23)
Step Over, Step Out and Run to Cursor (05:47)
Breakpoints (06:10)
Variable Values and the Data Tips Window (04:31)
The Quick Watch Dialog Box and Watch Window (10:43)
The Locals Window (03:39)
Tracking Object Variables (07:12)
Application Modes (08:07)
Exploring Application Modes (04:07)
Design Mode & Running Mode Demonstrations (05:21)
Run Time Editing and Compiling (04:21)
Summary (01:20)
Using Functions
Overview (01:41)
Using User Defined Functions (06:31)
Changing Function Categories (04:42)
Creating New Function Categories (07:07)
Formulae and the Worksheet Function Object (05:00)
VBA and Excel Function Differences (05:52)
Summary (01:41)
Code Production and Management
Overview (01:34)
Automated Placement of Statements (05:51)
Accessing Code (08:31)
Using Project References (05:47)
Saving Code (03:11)
Password Protection (05:36)
Summary (01:58)
Cell Referencing
Overview (02:45)
The Range Property and Selecting Cells (04:53)
Specifying Multiple Cell Ranges (05:51)
Qualifying Ranges Returned and Offsets (07:50)
Other Range Returning Properties (08:52)
Labels and Names (05:51)
Ranges in Other Workbooks (05:48)
Shorthand Notation and 3-D Ranges (05:21)
Summary (01:16)
Control Structures
Overview (02:40)
With Control Structure (06:53)
IF...Then...Else Control Structure (08:39)
Select Case Control Structure (08:06)
For...Next Loops (07:48)
For Each... Next Loops (06:35)
Do While...Loop and Do Until...Loop (06:59)
Do...Loop While and Do...Loop Until (02:43)
Summary (01:22)
Interacting With Users
Overview (02:46)
The Message Box (07:29)
The Message Box Constants (07:26)
The Input Box (06:40)
Object Positioning (04:57)
Quiz Example (06:35)
Protecting Users (07:57)
Summary (01:48)


http://rapidshare.com/files/36019881/VETECEEXELVEBEA.part1.rar
http://rapidshare.com/files/36025855/VETECEEXELVEBEA.part2.rar
http://rapidshare.com/files/36030547/VETECEEXELVEBEA.part3.rar
http://rapidshare.com/files/36013772/VETECEEXELVEBEA.part4.rar

Password: None