Learn Microsoft Visual Basic for Excel

Unlimited Online Training and Tutorials

Microsoft Visual Basic for Excel Online Video Training and Tutorials by Pravah Pugh consists of approximately 8 hours of training over 104 lessons. Start learning right now, free. Just click any lesson below to begin.

Course Outline For:

Microsoft Visual Basic for Excel

Start learning Microsoft Visual Basic for Excel right away, Free! Click on the highlighted lesson links below to view the lessons immediately. You will require Quicktime. If you have any problems viewing the lessons, click here

Introduction

Course Overview

Macros and VBA - A Demonstration

Using Excel Online Help

Using Visual Basic Online Help

Locating Information Across Help Files

Macros - the Quick Solution

Overview

Macro Virus Protection

Recording a Macro

Running a Macro

Reviewing and Organizing Recorded Code

Changing a Macros Functionality

Controlling Access to Macros

Simplifying Access to Macros

Summary

The VBA Programming Language

Overview

Objects and Collections

Methods; Properties and Events

Procedures and Functions

Executable Statements

Assignment Statements

Declaration Statements

Variables and Constants

Scope

Lifetime and Data Type

Summary

More lessons below ...

Would you like to continue? You can have instant access to the rest of this training for just $30.00

Subscribe Now!

The VBA Development Environment

Overview

Windows

Command Bars

The Code Window

Margin Indicator Bar

Code Interpretation

Type and Status Formatting

Entering Keywords

Syntax Assistance

The Project Explorer

The Properties Window

The Object Browser

Using the Object Browser

Summary

Development and Troubleshooting

Overview

Running Code and Debug Printing

Step Into, Break Mode and the Call Stack

Step Over, Step Out and Run to Cursor

Breakpoints

Variable Values and the Data Tips Window

The Quick Watch Dialog Box and Watch Window

The Locals Window

Tracking Object Variables

Application Modes

Exploring Application Modes

Design Mode & Running Mode Demonstrations

Run Time Editing and Compiling

Summary

Using Functions

Overview

Using User Defined Functions

Changing Function Categories

Creating New Function Categories

Formulae and the Worksheet Function Object

VBA and Excel Function Differences

Summary

Code Production and Management

Overview

Automated Placement of Statements

Accessing Code

Using Project References

Saving Code

Password Protection

Summary

Cell Referencing

Overview

The Range Property and Selecting Cells

Specifying Multiple Cell Ranges

Qualifying Ranges Returned and Offsets

Other Range Returning Properties

Labels and Names

Ranges in Other Workbooks

Shorthand Notation and 3-D Ranges

Summary

Control Structures

Overview

With Control Structure

IF...Then...Else Control Structure

Select Case Control Structure

For...Next Loops

For Each... Next Loops

Do While...Loop and Do Until...Loop

Do...Loop While and Do...Loop Until

Summary

Interacting With Users

Overview

The Message Box

The Message Box Constants

The Input Box

Object Positioning

Quiz Example

Protecting Users

Summary

Microsoft Visual Basic for Excel Video Training Detail:

Instructor:	Pravah Pugh
Course Lessons:	104 Total Lessons
Course Duration:	8hrs total
First Release Date:	2001-12-17
Course Price:	N/A - Included with membership
Monthly Membership:	$30 month to month
Annual Membership:	$250 annually
Courses Included:	ALL Training Titles

Sign Up Now and Start Learning!

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.

Sign Up Now and Start Learning!

WHY BECOME A MEMBER?

This is the easiest, best, most cost effective way to learn Microsoft Visual Basic for Excel from VTC Instructor Pravah Pugh?

Huge Learning Library Included - Access to one course includes access to our entire learning library of over 400 courses with 55,000+ lessons.

Superior Teaching Methods - No Books or classrooms! Combined video and audio delivered on your PC or Mac in bite size lessons - superior learning and retention. Many courses includes downloadable work files!

Flexible Learning - Learn on your schedule, at your pace... starting 60 seconds from now if you like!

Certifications - Downloadable (and third party verifiable) Certificates of Completion with each course you complete.

No Long Term Commitment - You CAN subscribe for a year to save $$, but you are also welcome to go month to month and cancel or suspend at anytime, no questions asked.

Proven Worldwide - Tens of thousands of students, professionals, small businesses, big businesses, schools, and governments around the globe use our training - Over 400 new members join every day.

Sign Up Now and Start Learning!

Students | Small Business | Big Business | Government | Schools

Try ANY Course Free | Available Courses | Complete F.A.Q. | Multi-User Accounts | Training on CDRom