Microsoft Visual Basic for Excel Tutorial Video - Try for FREE

Introduction

• Course Overview Demo
• Macros and VBA - A Demonstration Demo
• Using Excel Online Help Demo
• Using Visual Basic Online Help Demo
• Locating Information Across Help Files Demo

Macros - the Quick Solution

• Overview Demo
• Macro Virus Protection Demo
• Recording a Macro Demo
• Running a Macro Demo
• Reviewing and Organizing Recorded Code Demo
• Changing a Macros Functionality Demo
• Controlling Access to Macros Demo
• Simplifying Access to Macros Demo
• Summary Demo

The VBA Programming Language

• Overview Demo
• Objects and Collections Demo
• Methods; Properties and Events Demo
• Procedures and Functions Demo
• Executable Statements Demo
• Assignment Statements Demo
• Declaration Statements Demo
• Variables and Constants Demo
• Scope Demo
• Lifetime and Data Type Demo
• Summary Demo

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