Microsoft Excel VBA Two Day Introduction

09/07/2017

Microsoft Excel VBA /Macros (Visual Basic for Applications) Two Day Introduction

This full two dayMicrosoft Excel VBA training course covers:

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

Scheduled courses are held regularly in Glasgow & Edinburgh, on-site courses by arrangement across Scotland.

See our upcoming schedule for this course in Glasgow  or  Edinburgh