Microsoft Visual Basic for Excel Tutorial Try for FREE
Select a tutorial category
Discounted Training Courses
Members of the VTC Online University have unlimited access to this tutorial. At the moment, you are in demo mode and only the first 3 chapters will play. But members have access to EVERY SINGLE TITLE IN OUR RANGE, i.e., over 40,000 tutorials on 400+ titles all with expert tutors. Where else can you get high quality one to one training for just $30.00 per month!
Benefits
:- 01. Unlimited viewing.
- 02. Downloadable working files.
- 03. Expert instructors.
- 04. Use at home / work or both.
- 05. Works on PC or Mac.
- 06. Telephone Tech support.
- 07. Cancel at any time.
- 08. 300+ courses for 1 low fee.
- 09. New titles added regularly.
- 10. 100% Guaranteed
Should you need any help, just call - contact details at the bottom of the page.
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
If you would like to own this Visual Basic for Excel training title on CD, you may purchase it from our online store, because we don't have to use the same level of compression on the CDs as we do with the online, the audio and video playback is of a higher quality. For a single low payment you can buy this
After you have completed a tutorial, a
In order to view the training, you must have the latest version of QuickTime installed. Please note that the online movies have been compressed for quicker downloads, CDs and DVDs have far higher audio and video quality.