Microsoft Excel Macros &
VBA Programming

Visual Basic for Application is the tool commonly used by people who wish to develop and use their own program to control Excel. Our VBA Programming in Microsoft Excel will show you how to add extra functionality to your Microsoft Excel workbook.
On this course you will write and edit a visual basic code for an Excel workbook, work with the various functions and features that will assist you to set up your coding, be able to comfortably identify and deal with errors.
The course will give you hands on experience via structured exercises during the session and will give you the opportunity to practice the skills you have learned.
To get the most out of this course you should be comfortable with using Microsoft Excel and the Microsoft Windows environment.

Course Duration

2 Days

Course Content

Download Course Content PDF

  • Introduction to Macros
    • Recording a Macro
    • Using Relative References
    • Running a Macro
    • Viewing the Code
  • Writing/Editing Code
    • The Visual Basic Editor
    • Editor Options
    • The Code Window
    • Modules and Procedures
  • Variables
    • Declaring Variables
    • Forcing Declaration
    • Arrays
  • Objects, Properties and Methods
    • The Excel Object Model
    • Referring to Worksheets and Workbooks
    • Working with Properties
    • Using Methods to Perform Actions
  • Using Range Objects
    • Cells / Range Properties
    • Other Useful Properties
    • Working with a Region
    • Naming Ranges
  • Dialog Boxes
    • Message Boxes
    • Input Boxes
  • Control Structures
    • If-Then-Else
    • Select Case
    • Do-While Loops
    • For-Next Loops
  • Modules and Procedures
    • Using Sub-Procedures
    • Scope of Variables
  • Function Procedures
    • Using Built-in VBA Functions
    • Writing Function Procedures
    • Using Standard Excel Functions
  • User Forms
    • Creating a Custom Dialog Box
    • Adding Controls
    • Setting Properties of a Control
    • Writing the VBA Code
  • Debugging Tools
    • Dealing with Logic Errors
    • Working in Break Mode
    • Stepping Through Code
  • Dealing with Errors
    • Error Handling Statements
    • Identifying Errors
  • Responding to Worksheet/Workbook Events
    • Where the code should go
    • Workbook Events Handlers
    • Worksheet Event Handlers

Download Full Course Schedule PDF

Ask a question


Please contact us to make a booking or book now on-line.

All courses are available for both scheduled (open) and dedicated (bespoke) delivery. Please contact us for details and pricing.

If you can’t see the course you are looking for – contact