Microsoft Visual Basic for Excel
Training
Provided by The Virtual Training Company
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 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
About The Training Provider: The Virtual Training Company
The Virtual Training Company - The Virtual Training Company started in California's Silicon Valley in 1996.
VTC grew quickly over the next three years and relocated first in 1999 to the beautiful town of Winchester, Virginia; and six years later to Stephens City, Virginia.
The company was founded by British born Mark Vernon who started producing CD-based training for Apple software. The format on the CDs - narrated...
