Compatibility: Win Vista, XP, 2000, 98, NT, Mac OS X, OS 9
Microsoft Visual Basic for Excel Training Description
• If your struggling with this seemingly complex programming language then help is at hand with these easy to follow, online Microsoft Visual Basic for Excel training tutorials.
• Using high quality video training movies, expert instructor, Pravagh Pugh takes users through all of the essential concepts, principles and techniques which will help you get to grips with Microsoft Visual Basic for Excel in the shortest time possible.
• As well as all of the important Microsoft Visual Basic for Excel tuition such as creating macros, the basics of the VBA programming language and the VBA development environment, pravagh also divulges numerous useful tips, tricks and techniques that are sure to boost your skills and confidence.
• Start learning right away by viewing the FREE Microsoft Visual Basic for Excel training tutorials by clicking any blue linked lesson above.
These best selling online Microsoft Visual Basic for Excel training videos are the fastest and most cost effective way to learn. Using narrated video tutorials to demonstrate key techniques and features, this easy-to-follow instruction will help you to learn rapidly and retain essential knowledge and skills. Commencing from the basics, this "for dummies" training method will help users feel at ease from the outset.
This tutoring method allows users to learn either at home or the office and on any Mac or PC with an internet connection, for as less than $1 a day!
So why not start learning now and see how millions have used this training method as an effective substitute for expensive Microsoft Visual Basic for Excel training courses or workshops, boring books and tedious PDF training manuals.
Microsoft Visual Basic for Excel Training - FREE Tutorials
FREE Microsoft Visual Basic for Excel Training
Learn Microsoft Visual Basic for Excel in the shortest time possible, start now with the linked tutorials below: (Please allow a few seconds to load)
To ensure the FREE tutorials below run smoothly, please view our short checklist - CLICK HERE
We hope you enjoyed the free lessons above. To view the complete contents including the chapters below, please purchase the CD. Alternatively you can sign up to the Online University and gain full, instant access to this, and all 450+ tutorials for only $30/£15 per month.
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
Sign up to the Online University and view over 400 titles for only $30/£15 per month
BENEFITS: 1 Minimum Sign Up: ONLY ONE MONTH! - Cancel at any Time 2 Unlimited Viewing 3 Downloadable Instruction Files/PDFs 4 Learn Microsoft Visual Basic for Excel from Expert Tutors 5 View on any Computer in the World 6 Works on PC and Mac 7 Full Support Offered 8 Easy to Follow Video Instructions - Visual Advantage Over Bulky
Microsoft Visual Basic for Excel User Guides / Help Manuals 9 550+ Online Classes- New Titles Added Weekly 10 A Truely Professional Study Guide
Learn how to work faster and smarter right now, CLICK HERE to sign up to the Online University
After a course is completed you are able to download a FREE certificate. This certifies that you have completed the training and that you now possess essential
skills and detailed knowledge of Microsoft Visual Basic for Excel
UK & Europe
Marrutt Software Training
Bellbrook Industrial Estate
Uckfield, East Sussex, TN22 1QL
United Kingdom
UK Tel: +44 (0) 1825 764057
UK Fax: +44 (0)1825 768841
US & Canada
Marrutt Software Training
244 5th Ave # 1877
New York, NY 10001
United States
US Tel: 646-736-7932
US Fax: 646-895-7649