...take part

Don't just take our word for it

We ask all our past delegates to rate our courses so you can decide if this course is really right for you - just click 'Hear what people say' to read ratings. If you've been on a course, log in to 'My Reed Learning' and leave your review to help others decide.

Introduction to Visual Basic for Microsoft Excel Course

  • Duration:2 Days
  • Cost:£350 + VAT
  • Ref:VBE

Manage your data through powerful VBA tools.

Book now >

Cost £350.00 Duration 2 days Code VBE

Course rating:

(0  vote)

What's this?

  • Hear what people say
  • Send to a friend
  • Add to favourites

Who is it for

This course is suitable for people who would like to use VBA to enhance their usage of Excel for a more professional result. A thorough understanding of Excel formulas and functions is required. A prior knowledge of Visual Basic is not required.

What is it about

A thorough introduction to the ins and outs of Visual Basic Programming for Excel, this course is designed to give you the solid grounding you need to make Excel work for you - not the other way round!

Course Overview

  • Macros: Writing; Editing
  • Assigning Macros to a button in the toolbar
  • Understanding The Visual Basic Integrated Development Environment; Its Components: Properties Window, Project Explorer and Code Window
  • Creating and Editing Modules, Objects and Procedures
  • Adding Input and Output Message boxes; Procedures and Conditions; Writing Private and Public and Sub-routines; Creating New Functions for use in Excel
  • Declaring Constants And Variables
  • Variable Types: Dim, Static and Const
  • Writing and Understanding Loops & Arrays; Do while and Do Until loops; Arrays: Static and Dynamic
  • Using Advanced “If”, “Elseif” and the “Case Selection” alternative

What will I get out of it?

By the end of this course you will be able to:

  • Maximise existing Excel functionality by learning how to write programmes
  • Automate repetitive, tedious and complex tasks by using advanced ‘If’ statements and macros
  • Update VBA programmes by learning how to edit and amend them

Accredited by

This course is accredited for CPD

  • Hear what people say
  • Send to a friend
  • Add to favourites

Get in touch 

 

0800 170 7777

Email us

What's new this month >