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 >