VBA For Excel Training

Course Details

Course Title

VBA For Excel Training

Duration

20 Hours

Overview

This VBA for Excel training course is designed to give a good working knowledge of Visual Basic for Applications – concentrating on Microsoft Excel.

However more advanced automation - particularly tasks that link spreadsheets and other office applications together - require VBA.

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.

Prerequisites

Before attending out VBA for Excel Training course you must have attended our Advanced Excel Course or have equivalent experience.

Course Objectives

Upon completion of this course, delegates will know how to:

Create and edit Macros.
Use and understand VBA code.
Link and combine spreadsheets and other Office applications.
Set up advanced automation features.

Onsite Training

This course can be run in-company anywhere & we can tailor the content to focus on your requirements.

Who is this course for?

This course is ideal for those who already possess and advanced level of experience with Excel (ideally after attending our Advanced Excel Course) and are looking to expand their knowledge further into other areas of the software's capability.

Related Courses

Outline Details

VBA For Excel Training Course Content

Creating Record Macros

Recording & running Macros
Macros Dialog Box
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 & the host application

The Project Explorer

Using the Project Explorer

The Properties Window

Changing a Property

Using Constants

Excel & 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 Formula 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

Google Sites

Report abuse