Woodthorpe IT Solutions Ltd


How we deliver our Visual Basic VBA course

Onsite Courses

  • We come to you
  • We bring all the equipment needed
  • The outline can be customised

Open Course Dates

  • You come to our venue
  • Suitable for individuals

Online Courses

  • Self paced
  • Budget Friendly
  • 24/7 Learning

Visual Basic

Introduction to Macros
  • What is a Macro?
  • Recording a Macro
  • Running a Macro
  • Relative References
  • Assigning a Macro to a Button on a Worksheet
  • Assigning a Macro to a Button on a Toolbar
  • Button Image Editor
Editing Macros
  • The Visual Basic Editor
  • The Project Explorer
  • The Code Window
  • Procedures
  • Inserting Comments
  • Printing a Visual Basic Module
  • The Range Object
  • What is the Range Object?
  • The Cells Property
  • The Range Property
  • Flexible Ranges
  • Range Contents
Workbooks and Sheets
  • Activating a Workbook
  • Activating a Worksheet
  • ThisWorkBook
  • Calling Worksheet Events
  • Calling Workbook Events
Debugging and Error Trapping
  • What are Errors?
  • Types of Error
  • Break Mode
  • Instant Watch
  • Stepping Through Code
  • Error Handling Worksheet and Workbook Events
  • Creating Line Labels for Error Handling
  • Writing Error Handling Code to Trap Errors
  • Error Handling to Resolve Errors
  • Resuming after Resolved Errors



Objects, Properties and Methods
  • Controlling Objects with their Properties
  • Performing Actions with Methods
  • Performing Multiple Actions on an Object
Variables and Constants Control Structures
  • Conditional Control Structures
  • Looping Control Structures
  • Non-Structured Statements
  • Subprocedures
Controls, Dialogue Boxes and Forms
  • Built-In Dialogue Boxes
  • Predefined Dialogue Boxes
  • Custom Forms
  • Worksheet Forms
  • Setting the Properties of a Control
  • User-Defined Forms
  • Adding Form Controls
  • Form Control Properties
  • Control and Dialogue Box Events
  • Displaying and Dismissing a User Form
  • Handling Form Controls
Toolbars and Display
  • Customising the Quick Access Toolbar
  • Customising the Ribbon
  • Using Worksheet Buttons
Function Procedures
  • Function Procedures
  • User-Defined Functions
  • Function Wizard
  • Excel Functions
Add-in Applications
  • What is an Add-in?
  • Creating an Add-In
  • Working with Excel Add-Ins

This course is a two day course but can be condensed in to a 1 day session.

What our customers say

© Woodthorpe IT Solutions Site by Ben Timney Business vector designed by Freepik
All prices on this site are excluding VAT unless otherwise stated.
Performing arts school database Video

No flash installed

IFA Practice Manager

No flash installed

Production Scheduling Tool

No flash installed

Format As Table Part 1

No flash installed

Format as a table part 2

No flash installed

Subtotalling a list

No flash installed

Sorting basics

No flash installed

Cell Styles

No flash installed

Remove Duplicates In List

No flash installed