2-days – £495 + vat

This VBA for Excel training course provides attendees with a good working knowledge of VBA (Visual Basic for Applications) and its application within Microsoft Excel. During this VBA for Excel Course, you’ll learn to create and edit macros from scratch, and get a comprehensive understanding of VBA code.

Excel with VBA Training Course Content

Creating Record Macros in Excel

• Recording a Macro
• Running a Macro
• Creating a Short-cut key to run a macro
• Running a Macro from the Macros Dialog Box
• Running a Macro with a Shortcut key
• Editing a Macro with Visual Basic
• Assigning a Macro to a Menu or Toolbar

The Excel Visual Basic Editor

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

Running VBA Code in Excel

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

The VBA Project Explorer

• Using the VBA Project Explorer

The Properties Window

• Changing a Property

Using Excel and Variable Constants

• Variable Constants
• Excel Constants

Using Excel Objects

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

Variables

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

Using Visual Basic Functions in Excel

• MsgBox Function
• InputBox Function
• Using a Set Statement

Building Formula Control Structures

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

UserForms in Excel

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

VBA Event Handling

• Auto Macros
• VBA Editing & Debugging
• Error Handling

VBA for Excel Training Course Prerequisites

If you are interested in attending the VBA for Excel training course you should have attended our Advanced Excel Training Course (or have equivalent experience) and have a good understanding of Excel functions and Templates.