Popular Search terms :

Microsoft Visual Basic for Excel Training

More Microsoft Visual Basic for Excel Categories Programming training - Business Applications training -
Microsoft Visual Basic for Excel Tutorials Online
Product Microsoft Visual Basic for Excel Details
Total Time : 8.00 hrs
Number of Movies : 93
Number of Discs : 1
Catalogue Number : 33286
Language : english
Author : Pravah Pugh
Sale Price : $99.95
Qty





View simillar products Programming training - Business Applications training -
Description Microsoft Visual Basic for Excel
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.
Sample - Preview the First 3 chapters of Microsoft Visual Basic for Excel video free. Free learning Microsoft Visual Basic for Excel online.

Introduction
movie image Course Overview
movie image Macros and VBA - A Demonstration
movie image Using Excel Online Help
movie image Using Visual Basic Online Help
movie image Locating Information Across Help Files

Macros - the Quick Solution
movie image Overview
movie image Macro Virus Protection
movie image Recording a Macro
movie image Running a Macro
movie image Reviewing and Organizing Recorded Code
movie image Changing a Macros Functionality
movie image Controlling Access to Macros
movie image Simplifying Access to Macros
movie image Summary

The VBA Programming Language
movie image Overview
movie image Objects and Collections
movie image Methods; Properties and Events
movie image Procedures and Functions
movie image Executable Statements
movie image Assignment Statements
movie image Declaration Statements
movie image Variables and Constants
movie image Scope
movie image Lifetime and Data Type
movie image 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

Sponsors