

	To receive updates and new releases, subscribe today

HOME

ABOUT US

HOW TO ORDER

PURCHASE ORDERS

RESELLERS

ARTICLES

VIEW BASKET

IT CERTIFICATION & TECHNICAL
MCSE 2003/2008
MCSE 2003/2008 with A+
MCSE 2003/2008 with CCNA
MCSA 2003/2008
Microsoft .NET 2005 Power Suite
MCPD.NET 2.0 Web C# Bundle
MCPD.NET 2.0 Web VB Bundle
MCPD.NET 2.0 Windows C#
MCPD.NET 2.0 Windows VB
MCITP: Database Administrator
MCITP: Database Developer
A+ Certification Bundle
Certified Ethical Hacker v6
Cisco CCNA
Cisco CCNP
CISSP 2007
IT Helpdesk Career Track
IT Security Career Track
Network Engineer Career Track
Computer Forensics and Electronic Discovery (CFED)

View Complete List...

DESKTOP & OFFICE
Office 2007 Training Bundle
Office 2003 Training Bundle
Acrobat 9 Essentials
Project 2007
PRINCE2 Foundation

View Complete List...

GRAPHICS & LAYOUT
Creative Suite 4 Design Bundle
Photoshop CS4 Essentials
Adobe CS4 Master Collection Bundle
Illustrator CS4 Essentials
Total Training Online Courses

View Complete List...

MULTIMEDIA & ANIMATION
Adobe CS4 Production Premium Bundle
After Effects CS4 Essentials
Premiere Pro CS4 Essentials
MOTU Digital Performer 6
Encore DVD Pro 2.0

View Complete List...

CAD & 3D
AutoCAD 2010
AutoCAD 2009
AutoCAD LT 2009
Civil 3D 2009
Inventor 2009

View Complete List...

SOFT SKILLS TRAINING
Better Business Writing
Excellence in Supervision
How to Get Things Done
Team Leadership
Assertiveness

View Complete List...

WEB DESIGN & INTERNET
Dreamweaver CS4 Essentials
Expression Studio 2 Bundle
Flash CS4 Pro Essentials
Creative Suite 3: Web Bundle
E-Commerce Introduction

View Complete List...

CareerVision is committed to providing our customers with the best service and products available.

We back our training products with a 100% Satisfaction or Your Money Back Guarantee, so you can buy worry free. More....

FAST, FREE UK DELIVERY
Order Today, Learn Tomorrow!

INTERNATIONAL DELIVERY
Free for this month Only

SECURE PAYMENT
PROCESSING

We Accept All Major Credit Cards, PayPal and Google Checkout

Credit Cards Accepted

A-Z COURSE LIST

WHAT'S NEW

FREE DEMOS

SPECIAL OFFERS

ONLINE TRAINING

Visual Basic for Excel

By VTC

Save £10 on all VTC CDs.
Promotion Code: VTCTEN

Visual Basic for Excel

Single CD	£79.00 + VAT
Multi User Network CD	£395.00 + VAT

More on Single User & Multi User Networkable CDs

Author - Pravah Pugh
Duration - 8 Hours

COURSE INTRODUCTION

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.

COURSE OUTLINE

Introduction to Visual Basic for Excel
Training Course Overview
Macros and VBA - A Demonstration
Using Excel Online Help
Using Visual Basic Online Help
Locating Information Across Help Files

VBA Macros - the Quick Solution
Overview
Macro Virus Protection
Recording a Macro in Visual Basic for Excel
Running a Macro
Reviewing and Organizing Recorded Code
Changing a Macros Functionality
Controlling Access to Macros
Simplifying Access to Macros
Tutorials Summary

The VBA Programming Language
Overview
Objects and Collections
Methods; Properties and Events
Procedures and Functions
Visual Basic for Excel Executable Statements
Assignment Statements
Declaration Statements
Variables and Constants
Scope in Visual Basic for Excel
Lifetime and Data Type
Tutorials Summary

The VBA Development Environment
Overview
Windows
Command Bars
The Code Window
Margin Indicator Bar
Visual Basic for Excel Code Interpretation
Type and Status Formatting
Entering Keywords
Syntax Assistance
The Visual Basic for Excel Project Explorer
The PropertiesWindow
The Object Browser
Using the Object Browser
Tutorials 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
Visual Basic for Excel Application Modes
Exploring Application Modes
Design Mode & Running Mode Demonstrations
Run Time Editing and Compiling
Tutorials Summary

Visual Basic for Excel 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
Tutorials Summary

Code Production and Management
Overview
Automated Placement of Statements
Accessing Code
Using Project References
Saving Code
Password Protection
Summary

Visual Basic for Excel 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
Tutorials Summary

VBA 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
Tutorials Summary

Printer friendly version

Top of page

A-Z COURSE LIST PROVIDERS CBT TRAINING CONTACT US SITEMAP

Flash Tutorials & Training Courses MCSE CBT Courses Adobe Photoshop Tutorials & Training Microsoft Certification Training

CareerVision
61 Caroline Street, Birmingham, B3 1UF, UK
Tel: 0121 248 2400, Fax: 0121248 2800,
Email: sales@cvision.co.uk |Web: www.cvision.co.uk

Website design by Aimpro UK

Terms