Microsoft Visual Basic for Excel
Author:David Bylund
Language:english
Category:Databases,
Lessons:0 | 0 hrs
Buy Now or get more information about 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.
Microsoft Visual Basic for ExcelMicrosoft 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. 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! Microsoft Visual Basic for Excel
First 3 Lessons Free Online (Press the links below to open up the free lessons. The lessons will open in a popup window from this screen and play in Quicktime):

Microsoft Visual Basic for Excel

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

01 Introduction
0101 Course Overview
0102 Macros and VBA - A Demonstration
0103 Using Excel Online Help
0104 Using Visual Basic Online Help
0105 Locating Information Across Help Files

02 Macros - the Quick Solution
0201 Overview
0202 Macro Virus Protection
0203 Recording a Macro
0204 Running a Macro
0205 Reviewing and Organizing Recorded Code
0206 Changing a Macros Functionality
0207 Controlling Access to Macros
0208 Simplifying Access to Macros
0209 Summary

03 The VBA Programming Language
0301 Overview
0302 Objects and Collections
0303 Methods; Properties and Events
0304 Procedures and Functions
0305 Executable Statements
0306 Assignment Statements
0307 Declaration Statements
0308 Variables and Constants
0309 Scope
0310 Lifetime and Data Type
0311 Summary

04 The VBA Development Environment
0401 Overview
0402 Windows
0403 Command Bars
0404 The Code Window
0405 Margin Indicator Bar
0406 Code Interpretation
0407 Type and Status Formatting
0408 Entering Keywords
0409 Syntax Assistance
0410 The Project Explorer
0411 The PropertiesWindow
0412 The Object Browser
0413 Using the Object Browser
0414 Summary

05 Development and Troubleshooting
0501 Overview
0502 Running Code and Debug Printing
0503 Step Into, Break Mode and the Call Stack
0504 Step Over, Step Out and Run to Cursor
0505 Breakpoints
0506 Variable Values and the Data Tips Window
0507 The Quick Watch Dialog Box and Watch Window
0508 The Locals Window
0509 Tracking Object Variables
0510 Application Modes
0511 Exploring Application Modes
0512 Design Mode & Running Mode Demonstrations
0513 Run Time Editing and Compiling
0514 Summary

06 Using Functions
0601 Overview
0602 Using User Defined Functions
0603 Changing Function Categories
0604 Creating New Function Categories
0605 Formulae and the Worksheet Function Object
0606 VBA and Excel Function Differences
0607 Summary

07 Code Production and Management
0701 Overview
0702 Automated Placement of Statements
0703 Accessing Code
0704 Using Project References
0705 Saving Code
0706 Password Protection
0707 Summary

08 Cell Referencing
0801 Overview
0802 The Range Property and Selecting Cells
0803 Specifying Multiple Cell Ranges
0804 Qualifying Ranges Returned and Offsets
0805 Other Range Returning Properties
0806 Labels and Names
0807 Ranges in Other Workbooks
0808 Shorthand Notation and 3-D Ranges
0809 Summary

09 Control Structures
0901 Overview
0902 With Control Structure
0903 IF...Then...Else Control Structure
0904 Select Case Control Structure
0905 For...Next Loops
0906 For Each... Next Loops
0907 Do While...Loop and Do Until...Loop
0908 Do...Loop While and Do...Loop Until
0909 Summary

10 Interacting With Users
1001 Overview
1002 The Message Box
1003 The Message Box Constants
1004 The Input Box
1005 Object Positioning
1006 Quiz Example
1007 Protecting Users
1008 Summary

Sponsors