Home » Training Courses » Microsoft Office and Desktop Applications Training » VBA For Excel Training

VBA For Excel Training

2 days - £470 + vat

VBA Excel Training Need help NOW?! Learn Excel basics step-by-step with our Free Microsoft Excel 2007 Tutorial

This VBA for Excel training course is designed to give a good working knowledge of Visual Basic for Applications – concentrating on Microsoft Excel. During this VBA for Excel Course students will learn to create and edit macros, and gain an understanding of VBA code.

The Visual Basic for Applications content of the training course can be applied to other Microsoft Applications.

Excel with VBA Training Course Content

Creating Record Macros

Recording a Macro
Running a Macro
Running a Macro from the Macros Dialog Box
Creating a Short-cut key to run a macro
Running a Macro with a Shortcut key
Assigning a Macro to a Menu or Toolbar
Editing a Macro with Visual Basic

Visual Basic Editor

Objects
Methods
Properties
Programming Tools
The Menu Bar

Running Code

Run mode and Design mode
Running Code from the development environment
Running Code from the host application

The Project Explorer

Using the Project Explorer

The Properties Window

Changing a Property

Using Constants

Excel Constants
Variable Constants

Excel Objects

Objects, Properties and Methods
Getting & Setting Properties
Calling Methods
Passing Arguments
Singular Objects & Collections of Objects

Variables

Dimensioning a variable
Using variables in routines
Object Variables

Using Visual Basic Functions

InputBox Function
MsgBox Function
Using a Set Statement

Building Formular Control Structures

If…Then Decision Structures
Logical Operators
Select Case Decision Structures
Case Else
Comparison Operators with Select Case Structure
For… Loops
Do Loops
While...Wend Statement

UserForms

Designing & Creating Forms
Working with Controls
Creating Custom Dialog Boxes
Userform Properties Methods & Events

Event Handling

VBA Editing & Debugging
Auto Macros
Error Handling

Excel with VBA Course Prerequisites

Delegates should have attended the Advanced Excel Course and have a good understanding of Excel functions and Templates.

Excel VBA Training Course Recommended Reading

Excel VBA Programming for Dummies by John Walkenbach - buy from amazon

Download course outline as pdf.

+44 (0)1273 622272

VBA For Excel Training course dates

27 - 28 May 2010
7 - 8 Oct 2010