VBA for Excel

VBA for Excel



Next Date




Course Description

This course is ideally aimed at experienced Excel users who wish to go beyond using formulas on their spreadsheets.

Course Content

Excel and Macro’s, the basics

Recording visual basic “Macros” | The visual basic environment | Assigning code to buttons, menu’s and toolbars | The “Personal Macro Workbook”

Writing visual basic code

Modules and procedures (private and public) | Properties and methods | Variables | Dim | If…Then…Else | Select Case  | Do…Loop

Testing and debugging applications

Using the debug window | Starting, halting and tracing execution | Resolving compile and run-time errors | Working with breakpoints

Error handling and trapping

On error statement | Resume points

Delegates will be encouraged to write their own VBA code to help them learn and appreciate what they are doing

Related courses

VBA Programming Introduction

VBA Programming Intermediate

VBA for Excel Advanced


Simply complete the form below and we'll come back to you as soon as possible