United States Microsoft Visual Basic for Excel Tutorials
Online Contents For This Course
We have made some of the video tutorials for
Microsoft Visual Basic for Excel
freely available to help you evaluate our training. Click on any of the linked lesson listings below to preview FREE!
Course Description
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.
Choose your media type:
|
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) | T | |
| Windows | (08:42) | T | |
| Command Bars | (02:22) | T | |
| The Code Window | (05:25) | T | |
| Margin Indicator Bar | (02:52) | T | |
| Code Interpretation | (05:26) | T | |
| Type and Status Formatting | (04:36) | T | |
| Entering Keywords | (05:25) | T | |
| Syntax Assistance | (05:10) | T | |
| The Project Explorer | (07:28) | T | |
| The PropertiesWindow | (03:10) | T | |
| The Object Browser | (10:47) | T | |
| Using the Object Browser | (05:51) | T | |
| Summary | (00:58) | T | |
|
Development and Troubleshooting
|
|||
| Overview | (02:00) | T | |
| Running Code and Debug Printing | (05:57) | T | |
| Step Into, Break Mode and the Call Stack | (05:23) | T | |
| Step Over, Step Out and Run to Cursor | (05:47) | T | |
| Breakpoints | (06:10) | T | |
| Variable Values and the Data Tips Window | (04:31) | T | |
| The Quick Watch Dialog Box and Watch Window | (10:43) | T | |
| The Locals Window | (03:39) | T | |
| Tracking Object Variables | (07:12) | T | |
| Application Modes | (08:07) | T | |
| Exploring Application Modes | (04:07) | T | |
| Design Mode & Running Mode Demonstrations | (05:21) | T | |
| Run Time Editing and Compiling | (04:21) | T | |
| Summary | (01:20) | T | |
|
Using Functions
|
|||
| Overview | (01:41) | T | |
| Using User Defined Functions | (06:31) | T | |
| Changing Function Categories | (04:42) | T | |
| Creating New Function Categories | (07:07) | T | |
| Formulae and the Worksheet Function Object | (05:00) | T | |
| VBA and Excel Function Differences | (05:52) | T | |
| Summary | (01:41) | T | |
|
Code Production and Management
|
|||
| Overview | (01:34) | T | |
| Automated Placement of Statements | (05:51) | T | |
| Accessing Code | (08:31) | T | |
| Using Project References | (05:47) | T | |
| Saving Code | (03:11) | T | |
| Password Protection | (05:36) | T | |
| Summary | (01:58) | T | |
|
Cell Referencing
|
|||
| Overview | (02:45) | T | |
| The Range Property and Selecting Cells | (04:53) | T | |
| Specifying Multiple Cell Ranges | (05:51) | T | |
| Qualifying Ranges Returned and Offsets | (07:50) | T | |
| Other Range Returning Properties | (08:52) | T | |
| Labels and Names | (05:51) | T | |
| Ranges in Other Workbooks | (05:48) | T | |
| Shorthand Notation and 3-D Ranges | (05:21) | T | |
| Summary | (01:16) | T | |
|
Control Structures
|
|||
| Overview | (02:40) | T | |
| With Control Structure | (06:53) | T | |
| IF...Then...Else Control Structure | (08:39) | T | |
| Select Case Control Structure | (08:06) | T | |
| For...Next Loops | (07:48) | T | |
| For Each... Next Loops | (06:35) | T | |
| Do While...Loop and Do Until...Loop | (06:59) | T | |
| Do...Loop While and Do...Loop Until | (02:43) | T | |
| Summary | (01:22) | T | |
|
Interacting With Users
|
|||
| Overview | (02:46) | T | |
| The Message Box | (07:29) | T | |
| The Message Box Constants | (07:26) | T | |
| The Input Box | (06:40) | T | |
| Object Positioning | (04:57) | T | |
| Quiz Example | (06:35) | T | |
| Protecting Users | (07:57) | T | |
| Summary | (01:48) | T | |
Email this Page
Send us FeedbackCourse Information
| Course: | Microsoft Visual Basic for Excel |
| Author: | Pravah Pugh |
| SKU: | 33286 |
| ISBN: | 1930519567 |
| Release Date: | 2001-12-17 |
| Duration: | 8 hrs / 93 tutorials |
| Captions: | For Online University members only |
Search within Captions
Subscription / Purchase Information
Visitors to VTC.com will be able to view all introductory videos for each training course.
Free Trial Members will gain access to first three chapters for each training course.
Sign up for a Free Trial
Full Access Members have full access to VTC.com’s entire library of video tutorials.
If you are already a member, please login here.