Browse all IT training courses

Excel Macros and VBA Programming Introduction

Click here for a PDF version

Introduction

Microsoft Excel is the latest release of one of the world's leading Windows spreadsheet programs. Visual Basic for Applications is the programming language used when Macros are recorded and can turn a laborious manual process into a one-click function. 

Objectives

To show how to record and run Macros. To teach the basics of VBA programming so that trainees can edit existing Macros and create their own procedures from scratch. By the end of the course participants will be able to further develop specific applications and models. 

Designed for

Existing users of Excel Participants should have attended our "Microsoft Excel Advanced" course or attained a similar level of proficiency. 

Duration

One day 

Topics

  • Introducing VBA concepts and terms
  • How macros can automate your work
  • Recording, editing and debugging macros
  • Creating automatically executed macros
  • Creating Macro buttons
  • Creating Dialog boxes
  • Customising a menu
  • Making decisions within a Macro
  • Repeating actions within a Macro
  • Working with Modules
  • Advanced macro commands

Follow-up

Individual consultancy and tuition as required 

Get in Touch

Pricing Guide:

  • 1

    £495 per head

  • 4

    £130 per head

  • 8

    £70 per head

Ask us about training for roll-outs and bespoke systems.

…and every course includes

  • Custom-building the course for you
  • Free post-course support helpline
  • All course materials
  • Trainer expenses