VTC - Microsoft Visual Basic for Excel Tutorials

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 Properties Window
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