SUMMER OFFER - only £595 a day!

Microsoft Excel VBA Macros Level 1 (1 day recommended)

This introduction to VBA programming will familiarise delegates with the core features of Microsoft Excel VBA. At the end of the training, delegates will understand VBA syntax and structure and be able to write and deploy basic macros using VBA.

The course is suitable for those with a good knowledge of all of Excel's basic and intermediate features and techniques.

Course Outline

Basics

Excel VBA overview
Understanding macro steps
Modifying macro steps
Storing values in variables
Adding comments to your code
Stepping through macros
Getting help on macros
Objects, properties and methods
About Excel objects

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

Using Visual Basic

Language structure
Using variables
Declaring variables
Data types
Making decisions
If statements
Looping structures

Interactivity

Assigning a macro to a menu
Assigning a macro to a toolbar
Assigning macros to other objects
Built-in dialogue boxes
Using form controls

Back to top