Wednesday, 9 March 2011

VTC - Microsoft Visual Basic for Excel



VTC - Microsoft Visual Basic for Excel
Pravah Pugh | 2001-12-17 00:00:00 | | 0 | Video (tutorials, how-to, etc.)
Details of content covered in this:

Introduction
Course Overview (04:11)
Macros and VBA - A Demonstration (12:07)
Using Excel Online Help (05:10)
Using Visual Basic Online Help (04:47)
Locating Information Across Help Files (07:54)

Macros - the Quick Solution
Overview (03:08)
Macro Virus Protection (01:54)
Recording a Macro (08:34)
Running a Macro (06:06)
Reviewing and Organizing Recorded Code (08:16)
Changing a Macros Functionality (02:19)
Controlling Access to Macros (10:07)
Simplifying Access to Macros (03:53)
Summary (01:39)

The VBA Programming Language
Overview (02:32)
Objects and Collections (04:33)
Methods; Properties and Events (02:56)
Procedures and Functions (07:35)
Executable Statements (03:21)
Assignment Statements (04:06)
Declaration Statements (05:27)
Variables and Constants (04:00)
Scope (04:44)
Lifetime and Data Type (09:26)
Summary (00:56)

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)

Video duration - 8 hrs / 93 tutorials bundled in an ISO format (9 parts), will require quicktime player for playing these files.

Thanks and all credits to the original uploader.

Enjoy!!!

I will be uploading all the parts by today one by one, kindly bear with me.
Download this book!

Free Ebooks Download

No comments:

Post a Comment