For training call +44 1273 622272

Your basket is empty View Cart shopping cart

VBA For Excel Training

Taught me a lot of new things and provided good revision on other areas. The course focused on practical applications such as designing forms, as well as giving some theoretical background.

David Stone - Esure Ltd

MAKE AN ENQUIRY Download Course Outline

This VBA for Excel training course is designed to give a good working knowledge of Visual Basic for Applications – concentrating on Microsoft Excel.

VBA for Excel Training

Many advanced Excel users know how to use Macros to automate tasks by recording them using the Macro recorder, and running them at a later date.

However more advanced automation - particularly tasks that link spreadsheets and other office applications together - require VBA.

During this VBA for Excel Course students will learn to create and edit macros, and gain an understanding of VBA code.

The Visual Basic for Applications content of the training course can be applied to other Microsoft Applications.

We also provide private and in-company VBA for Excel courses. Call +44 (0)1273 622272 to discuss.

Video: Introduction to VBA for Excel

This video provides a useful introduction to what Excel VBA is and how to access the Developer toolbar:

VBA for Excel Training


What are the objectives of the VBA For Excel training course?

Upon completion of this course, delegates will know how to:

  • Create and edit Macros.
  • Use and understand VBA code.
  • Link and combine spreadsheets and other Office applications.
  • Set up advanced automation features.

Who’s the VBA For Excel Course intended for?

This course is ideal for those who already possess and advanced level of experience with Excel (ideally after attending our Advanced Excel Course) and are looking to expand their knowledge further into other areas of the software's capability.

Course Feedback

A good introduction to basics followed by the introduction of more complex functions. Very good coverage of a very complex subject.

David Palmer - ISP Microcaps UK Ltd

Good working through the pre-coding stages, e.g drawing the problem out on paper and following it through logically.

Stuart Taylor - Brighton & Hove City Council

Good pace, covering relevant content to us. Good mix of demonstrated examples & tasks to work through individually. Trainer always on hand to answer questions and very approachable

Matthew Schofield - Esure Ltd

Filled in lots of holes in my knowledge. Particularly liked the usage of forms, learning the syntax for referring to controls within the form.

Jack Ringshall - Esure Ltd

The tutor was very passionate about VBA and was able to fund solutions to all our problems, if he didn't know he investigated alongside us.

Sarah Drane - Esure Ltd

VBA For Excel Training Course Content

Creating Record Macros

  • Recording & running Macros
  • Macros Dialog Box
  • Editing a Macro with Visual Basic

Visual Basic Editor

  • Objects, Methods, Properties
  • Programming Tools
  • The Menu Bar

Running Code

  • Run mode and Design mode
  • Running Code from the development environment & the host application

The Project Explorer

  • Using the Project Explorer

The Properties Window

  • Changing a Property

Using Constants

  • Excel & Variable Constants

Excel Objects

  • Objects, Properties and Methods
  • Getting & Setting Properties
  • Calling Methods
  • Passing Arguments
  • Singular Objects & Collections of Objects

Variables

  • Dimensioning a variable
  • Using variables in routines
  • Object Variables

Using Visual Basic Functions

  • InputBox Function
  • MsgBox Function
  • Using a Set Statement

Building Formula Control Structures

  • If…Then Decision Structures
  • Logical Operators
  • Select Case Decision Structures
  • Case Else
  • Comparison Operators with Select Case Structure
  • For… Loops & Do Loops
  • While...Wend Statement

UserForms

  • Designing & Creating Forms
  • Working with Controls
  • Creating Custom Dialog Boxes
  • Userform Properties Methods & Events

Event Handling

  • VBA Editing & Debugging
  • Auto Macros
  • Error Handling

Booking

* Required

For in-company or private training please request a quote

 
 

Total price (excluding any discounts and offers)

Book/Buy Now

Course Details

  1. Course Title

    VBA For Excel

  2. Duration

    2 Days

  3. Price Starting From

    £695.00 + VAT

Upcoming Dates

Manchester, UK

  1. 20 - 21 Oct 2017
  2. MORE DATES

Sheffield, UK

  1. 20 - 21 Oct 2017
  2. MORE DATES

Brighton, UK

  1. 23 - 24 Oct 2017
  2. MORE DATES

Reading, UK

  1. 27 - 28 Oct 2017
  2. MORE DATES

Cambridge, UK

  1. 27 - 28 Oct 2017
  2. MORE DATES

Milton Keynes, UK

  1. 27 - 28 Oct 2017
  2. MORE DATES

London, UK

  1. 03 - 04 Nov 2017
  2. MORE DATES

Aberdeen, UK

  1. 03 - 04 Nov 2017
  2. MORE DATES

Nottingham, UK

  1. 10 - 11 Nov 2017
  2. MORE DATES

Birmingham, UK

  1. 10 - 11 Nov 2017
  2. MORE DATES

Southampton, UK

  1. 17 - 18 Nov 2017
  2. MORE DATES

Cardiff, UK

  1. 17 - 18 Nov 2017
  2. MORE DATES

Liverpool, UK

  1. 24 - 25 Nov 2017
  2. MORE DATES

Belfast, UK

  1. 24 - 25 Nov 2017
  2. MORE DATES

Norwich, UK

  1. 24 - 25 Nov 2017
  2. MORE DATES

Edinburgh, UK

  1. 01 - 02 Dec 2017
  2. MORE DATES

Dublin, UK

  1. 01 - 02 Dec 2017
  2. MORE DATES

Newcastle, UK

  1. 08 - 09 Dec 2017
  2. MORE DATES

Leeds, UK

  1. 29 - 30 Dec 2017
  2. MORE DATES

Bristol, UK

  1. 29 - 30 Dec 2017
  2. MORE DATES

Glasgow, UK

  1. 29 - 30 Dec 2017
  2. MORE DATES

Bournemouth, UK

  1. 12 - 13 Jan 2018
  2. MORE DATES

Who is this course for?

Before attending out VBA for Excel Training course you must have attended our Advanced Excel Course or have equivalent experience.