Ms Excel VBA Courses

Advanced VBA Microsoft Excel Training Course Information

Microsoft  Excel – VBA Training Course

1 Day Course
*Book 2 or more delegates and receive significant discounts. Click here for information

This course is run on demand. Please call 0845 402 2781 for details.

Introduction

This one day course is designed for delegates wishing to automate common worksheet operations, to convert worksheets into forms and to understand Excel VBA code.
On completion of this course delegates will be able to design macros, to edit VBA code and to build procedures which interact with the users.

Course Objectives

  • Record macros to automate tasks
  • Write control structures
  • Create custom functions
  • Build user forms
  • Build procedures using variables

Pre-requisites

Delegates should have already attended an Excel Advanced course or be able to demonstrate equivalent knowledge.

Course Content

  • Introduction to Excel VBA
  • Recording and running procedures
  • Viewing and editing procedures
  • Working with Visual Basic Code
  • Understanding Objects, Properties and Collections
  • Simple user input
  • Control and looping
  • Debugging
  • Error handling
  • Customising the User Interface