Microsoft Visual Basic for Excel |
CD Contents
For This Title |
Tutorial
Information / Pricing |
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.
|
| Title: |
Microsoft Visual Basic for Excel |
| Author: |
Pravah Pugh |
| Price |
129.95 |
| Duration: |
8 hrs / 104 lessons |
| Compatibility: |
Win XP, 2000, 98, NT, Mac OS X, OS 9 |
|
Buy Now |
Paypal Buy |
|
Never has it been so easy to learn Microsoft Visual Basic for Excel
- No expensive classroom training courses.
- No boring hard to follow books to read.
- Learn from your own desk at a pace that suits you.
- High quality affordable training that is easy to use and follow.
- Use our unique training method, it makes learning easy no matter what
your learning style.
|
Listed below are all of the chapter and lesson contents for the Microsoft Visual Basic for Excel
Try For Free Right Now
To help you evaluate our training, we have made some of the tutorials for
Microsoft Visual Basic for Excel freely available. Click on any of the linked lesson listings
below to preview Free!

|
 The first three course lessons are provided Free To view. A Quicktime player is recommened for this computer training. The online training samples have been compressed for quicker downloads. Actual 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. |
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
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 PropertiesWindow
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
|