Woodthorpe IT Solutions Ltd

visual-basic-vba_01_01

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

From £500 per day
(additional expenses may be payable)

Open Course Dates

  • You come to our venue
  • Suitable for individuals

From £125 per day per person

Online Courses

  • Self paced
  • Budget Friendly
  • 24/7 Learning

From £29 per person


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

North West Office

Woodthorpe IT Solutions Ltd
4 Haycroft Close
Great Sutton
Ellesmere Port
Cheshire
CH66 2GY

Registered No. 05572129

VAT No. 936 2824 09

North East Office

Woodthorpe IT Solutions Ltd
13 Queensway House
Middlesbrough
Cleveland
TS3 8TF

Telephone

0800 044 3779

Email

contactus@woodthorpeitsolutions.co.uk

top
© 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

×