Microsoft Visual Basic for Excel Tutorial Try for FREE

The fastest and most cost effective way to learn! Forget boring books! No need for expensive classroom training - just easy to follow training videos that play right from your own computer. Login from home or office - the choice is yours. All courses are taught by world leading experts, unlimited access, on over 400 different subjects.

Please Note:
You are in Demo mode which only allows access to the first 3 chapters of this Microsoft Visual Basic for Excel training course and all the other titles listed on this site, this is to help you evaluate the quality of the training before joining. If you decide to join, you will instantly have totally UNLIMITED ACCESS to over 400 professionally created video tutorials, you will be able to access the content from any location and no restrictions are placed on the amount of content you can watch, you can also cancel at any time you wish. Over 4000 hours of training for just $30.00.

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