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

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.