...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.

Advanced Visual Basic for Excel Course

  • Duration:1 Day
  • Cost:On request
  • Ref:AVBE

Master Excel with Powerful VBA tools

Get Dates and Book
Book now >

Cost £199.00 Duration 1 day Code AVBE

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 great for people who want a more professional result using Excel.  If you already have a thorough understanding of Excel formulae and functions, and use some Visual Basic programming, this course is for you.

What is it about

A step up from our introductory course, this day takes you through advanced methods of data management and smart uses of VBA programmes.

Course Overview

  • Macros: Debugging and Tracing Errors in Macros
  • Visual Basic Objects
  • Range, Object Flexibility and Constraints
  • Object Hierarchy
  • Workbooks and Worksheets
  • Activating Worksheets and Workbooks through VBA
  • Constants and Variables
  • Structure, Control and Conditional Structure Control
  • Sub-Routines and Non-Structured Information
  • Customising Forms and Dialogue Boxes
  • Using Forms with Pre-Defined Dialogue Boxes
  • Form Controls and Properties; Customised Forms
  • Adding in Other Applications
  • What are Add-Ins?
  • Generating an Add-In
  • Using Add-Ins in a Workbook
  • Error Handling within the Programme Logic

What will I get out of it?

By the end of this course you will possess:

  • The Skills to Maximise Excel Functionality
  • In Depth Understanding of how to Edit, Amend and Update VBA Programmes
  • Improved Interfaces between Excel Spreadsheets
  • An advanced understanding of methods of data management through powerful VBA tools

    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 >