Menu

    Call us on:
    07477 578417

Excel VBA training Leatherhead

We have now resumed face-to-face training. However, we are happy to provide remote training via Microsoft Teams or Zoom for those who would prefer to learn in this way. Click here for further details.

If you’re looking for really great Microsoft Excel VBA training Leatherhead you’re in the right place.

Companies large and small choose us – why? Your own tailored, Microsoft Excel VBA training course, at your own premises at the same price as a standard course from elsewhere.

When working with a Microsoft Excel workbook becomes repetitive, it makes sense to create a macro to automate the task. Simple macros can be recorded in Microsoft Excel itself. If you want to create complex macros in Microsoft Excel then using VBA (Visual Basic for Applications) will enable you to program your own. This course is designed to teach you how.

The JMD Training difference is clear:

  • We come to you – your Microsoft Excel VBA training Leatherhead will be given on your site
  • You get to keep the manuals – Excel VBA training manuals are provided as PDFs
  • We can train using your own Microsoft Excel workbooks
  • There will only be people from your company on your course
  • We offer a money-back guarantee if any delegates are not completely satisfied
  • The training date is around you, not us!
  • Our prices are astounding
  • We can assess all learners in advance for free
  • Our courses are never cancelled

Our Microsoft Excel VBA training Leatherhead courses, are available not only in Leatherhead, but in all surrounding areas.

Request Course Now »

Course Type Cost per day
1 to 1 training £345
2 to 4 delegates £525
5 to 8 delegates £745

Prices are PER DAY, and NOT per-person! E.g. if there’s 5 people on the course, you pay £745. All prices exclude VAT

We also cover a range of other Microsoft Excel training Leatherhead courses.

Provisional course outlines:

 

Visit our blog If Only I’d Known That,; we have called it that because we hear it so many times in training sessions. In fact, if only we had an extra £100 for every time someone says “If only I’d known that.” ….

Clients benefitting from our Excel VBA training include:

Aims of the course

This course covers automation and customising of Excel using macros and screen items (such as buttons and menus). Delegates learn how to write macros using VB code and assign macros to screen items

Course Objectives

On completion of the course delegates will have gained confidence in using Excel VBA. They will be able to:

  • Use the Macro Recorder to record macros
  • Use VBA to create and edit macros
  • Use objects and dialog boxes
  • Work with VBA controls
  • Use variables, arrays and functions
  • Work with Active Data Objects
  • Create add-ins

The course is of two days' duration. However, a one day course outline can be provided on request.

How the course is run

This instructor-led course has a hands-on approach, with plenty of opportunity for delegates to practise the new skills they learn at the computer.

Pre-requisites

Familiarity with the Windows environment, and a good knowledge of Excel. Prior attendance of the Advanced Excel course would be an advantage.

Introduction and the Macro Recorder

  • Recording a macro using the Macro Recorder
  • Recording a macro using absolute cell references
  • The Personal Macro Workbook
  • Assigning shortcut keys
  • Deleting macros
  • Recording macros using relative cell references

Using VBA to Create and Edit Macros

  • The concepts of storing macros
  • Using the VB Editor
  • Using Visual Basic Help
  • Closing the Visual Basic Editor
  • Understanding Macro Security

Working with Procedures and Functions

  • Understanding modules
  • Creating a standard module
  • Copying and pasting procedures
  • Creating a sub procedure
  • Calling procedures
  • Linking procedures
  • Creating a function procedure
  • Naming procedures
  • Working with the Code Editor

Objects and Dialog Boxes

  • Introduction to objects
  • Navigating the Excel object hierarchy
  • Understanding collections
  • Introduction to the object browser
  • Searching the object browser
  • Working with properties
  • Using the With statement
  • Working with methods
  • Creating an event procedure

Using Expressions, Variables and Intrinsic Functions

  • Understanding expressions and statements
  • Declaring variables
  • Understanding data types
  • Working with variable scope
  • Using intrinsic functions
  • Understanding constants
  • Understanding intrinsic constants
  • Using message boxes
  • Using input boxes
  • Declaring object variables
  • Using object variables

Controlling Program Execution

  • Understanding control-of-flow structures
  • Boolean expressions
  • If, Else and Select Case
  • Do Loops
  • The For...To...Next structure
  • The For Each... Next structure
  • Using control-of-flow structures

VBA Forms and Controls

  • Creating userforms
  • Using the Toolbox
  • Working with userform properties, events and methods
  • Setting control properties in the Properties window
  • The label control
  • The text box control
  • The command button control
  • The combo box control
  • The frame control
  • Option button controls
  • Appearance of controls
  • Setting tab order
  • Populating a control
  • Adding code to controls
  • Launching a form in code

Working with the PivotTable Object

  • Using worksheet data to create a pivottable
  • Working with pivottable objects
  • Working with the pivotfield collection
  • Assigning a macro to a toolbar/Quick Access toolbar

Code debugging

  • Looking at errors
  • Using the debugging tools
  • Setting breakpoints
  • Stepping through code
  • Using Break mode
  • Working out the value of expressions

Error Handling

  • The VBA error tracking options
  • Using the On Error statement to trap errors
  • The Err object
  • Writing a routine to handle errors
  • Inline error items

Request Course Now »