Find a Course...Try for FREE

Microsoft Visual Basic for Excel Training Information
Author: Pravah Pugh
Duration: 8 hrs
Video Lessons: 104
Click here to sign up to the Online University
Compatibility: Win Vista, XP, 2000, 98, NT, Mac OS X, OS 9


Training Categories
    Graphics & Page Layout
    Internet & Web Design
    Animation & 3D
    Multi Media & Video
    Business
    Certification
    Operating Systems
    Databases
    Programming
    Music & Audio
    Tutorials Coming Soon

Microsoft Visual Basic for Excel Training - FREE Tutorials

FREE Microsoft Visual Basic for Excel Training
Learn Microsoft Visual Basic for Excel in the shortest time possible, start now with the linked tutorials below:   (Please allow a few seconds to load)
To ensure the FREE tutorials below run smoothly, please view our short checklist - 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

We hope you enjoyed the free lessons above. To view the complete contents including the chapters below, please purchase the CD. Alternatively you can sign up to the Online University and gain full, instant access to this, and all 450+ tutorials for only $30/£15 per month by clicking here
CLICK HERE TO BUY THIS TUTORIAL ON CD


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

CLICK HERE TO BUY THIS TUTORIAL ON CD




Sign up to the Online University and view over 400 titles for only $30/£15 per month
BENEFITS:
  1 Minimum Sign Up: ONLY ONE MONTH! - Cancel at any Time
  2 Unlimited Viewing
  3 Downloadable Working Files
  4 Learn from Expert Authors
  5 View on any Computer in the World
  6 Works on PC and Mac
  7 Full Support Offered
  8 450+ Courses for a Low Monthly Fee
  9 New Titles Added Weekly
  10 A Truely Professional Study Guide

Click here to sign up to the Online University

CLICK HERE TO BUY THIS TUTORIAL ON CD

Multi user options available for large organistions and education
CLICK Here for further info

Free Certificates available when each course has been completed


RECENTLY ADDED TUTORIALS
  ADOBE INDESIGN CS3
  ADOBE PHOTOSHOP CS3
  ADREAMWEAVER CS3
  APPLE FINAL CUT PRO 6
  MAYA 8.5 FOR BEGINNERS
  POSER 7
  AUTOCAD 2007
  MS PROJECT 2007
  ADOBE ILLUSTRATOR CS3
  MICROSOFT ACCESS 2007
  MICROSOFT VISTA
  ADOBE FLASH CS3
  AUTOCAD 2009