VTC - Microsoft Visual Basic for Excel - ISBN:1930519567

VTC - Microsoft Visual Basic for Excel

Date: 28 April 2011, 06:38

Free register and download UseNet downloader, then you can FREE Download from UseNet.

Download without Limit " VTC - Microsoft Visual Basic for Excel " from UseNet for FREE!

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.

Related Articles:
Excel

DISCLAIMER:

This site does not store VTC - Microsoft Visual Basic for Excel on its server. We only index and link to VTC - Microsoft Visual Basic for Excel provided by other sites. Please contact the content providers to delete VTC - Microsoft Visual Basic for Excel if any and email us, we'll remove relevant links or contents immediately.