We will be undergoing scheduled maintenance on May 20th, 2013 at 02:00 GMT.
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.
Macros and VBA - A Demonstration
Using Visual Basic Online Help
Locating Information Across Help Files
Running Code and Debug Printing
Step Into, Break Mode and the Call Stack
Step Over, Step Out and Run to Cursor
Variable Values and the Data Tips Window
The Quick Watch Dialog Box and Watch Window
Design Mode & Running Mode Demonstrations
Run Time Editing and Compiling
Creating New Function Categories
Formulae and the Worksheet Function Object
VBA and Excel Function Differences
The Range Property and Selecting Cells
Specifying Multiple Cell Ranges
Qualifying Ranges Returned and Offsets
Other Range Returning Properties
Shorthand Notation and 3-D Ranges
IF...Then...Else Control Structure
Do While...Loop and Do Until...Loop
Do...Loop While and Do...Loop Until
Every course on the vtc.com website contains free movies that let you assess the quality of our tutorials before you subscribe - just click on the blue links to watch them. Become a member today to access over 100,000 instructional videos!
Sign Up NowIf you are already an active vtc.com member, please log in to access the tutorials.