Microsoft Excel VBA Introduction

Description

Our Excel VBA Introduction shows delegates how to create and customise macros and gives them a basic familiarity with the Visual Basic for Applications environment. Best practices are introduced from the outset and delegates are encouraged to learn VBA by understanding its key principles, rather than simply memorising syntax.

The course is held in Peterborough at the following address:

Pinnacle House
4-5 Newark Rd
Peterborough
PE1 5WS.

Course Outline

Basics

Excel VBA overview, Understanding macro steps, Modifying macro steps, Calling one macro from another, Storing values in variables, Adding comments to your code, Stepping through macros, Getting help on macros

Objects, properties and methods

About Excel objects, Using the Object Browser , Range object, The Selection property

The Range property

Targetting cells, Counting the cells in a selection, Using the Offset statement, Retrieving the value of a cell, Retrieving a formula from a cell, Setting the value of cells

Charts and drawing

About programming charts, Assigning a range to a chart, Positioning a chart, Drawing shapes, Setting shape attributes

Using Visual Basic

Language structure, Using variables, Declaring variables, Scoping variables, Data types, Using constants, Using the VBA debugger

Making decisions

If statements, Select Case, Looping structures, Different types of loops, Manipulating arrays

Interactivity

Assigning a macro to a menu, Assigning a macro to a toolbar, Assigning macros to other objects, Built-in dialogue boxes, Creating custom forms, Using the Form Editor , Using form controls