Title Language  : 

Find a Course... Try for Free!

 

Microsoft Visual Basic for Excel Tutorials

Course Content
In Visual Training Company's tutorial Microsoft Visual Basic for Excel, Pravah Pugh helps you get started by going over macros, the VBA programming language, and the VBA development environment. He then teaches you about the use and creation of functions for Visual Basic for Excel and how to access and save code. You will also learn about cell referencing, labels, names and much more. To get started, simply click one of the topics below.
QT To view the Free Tutorials listed below, you must have QuickTime installed. Please note that the online free samples have been compressed for quicker downloads. Purchased CDs have higher sound and video quality.
Monitor resolution needs to be set to at least 1024 by 768 to view the entire movie.

лл Hide 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)

Email this Page     Send us Feedback
Tutorial Information / Pricing
Title: Microsoft Visual Basic for Excel
Author: Pravah Pugh
SKU: 33286
ISBN: 1930519567
Duration: 8 hrs / 93 Lessons
Compatibility: Win XP, 2000, 98, NT, Mac OS X, OS 9

Online University Access all our Training for only 30
The Online University provides unlimited 24/7 access to ALL of VTC's incredible training content for the low fixed price of just $30/month (USD)
SIGNUP LEARN MORE »

Get this title on CD
Single User: US$ 99.95 - Purchase CD / Add to Cart

Multi User (10): US$ 500.00 - Purchase CD / Add to Cart

Select Bandwidth
Click "High Bandwidth" if you want to view movies at the highest quality available. Click "Low Bandwidth" if on a slow dial-up connection (28 Kbps and such). The low bandwidth movies are slightly more compressed and smaller in file size, allowing for faster streaming.

Select:

Select Category

Special Groups

Publisher or Products