VBA for Excel

VBA for Excel

Cost

£145+VAT

Next Date

Enquire

Duration

One

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

BOOK THIS COURSE

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