Introduction to Excel Macros and VBA

Duration: 2 Days

Objectives

This example-based, hands-on course introduces delegates to the fundamentals of writing Excel macros. You will learn how to create procedures to automate your work, remove the risk of inconsistencies and errors in repetitive tasks and above all, to save time. You will learn to write and edit macros for Excel, using Visual Basic for Applications and the Integrated Development Environment.

Pre-requisites

This course assumes a sound grasp of Excel, including writing worksheet formulae such as SUM, MAX, MIN, AVERAGE etc and formatting data. Any experience of recording and stepping through macros will be beneficial, but is not a pre-requisite for attendance.

Course includes

A comprehensive set of reference notes covering course topics, follow-up telephone support and, for training on Transmedia premises, lunch and refreshments.

Course outline

Basics of writing VBA

  • Overview
  • Introduction

Selecting objects and setting values

  • Overview
  • Properties and methods
  • Named vs Positional arguments
  • Examples of Properties and Methods
  • Selecting cells and inserting data

Setting format properties

  • Adding formatting to a worksheet

Using variables to store information

  • Data types for variables

Interacting with the user

  • Using an InputBox to get information
  • Some examples of using the InputBox function
  • Using InputBoxes to automate headers and footers
  • Using a MsgBox to give information to the user
  • Using a MsgBox to get information from the user
  • MsgBox functions
  • InputBoxes, MsgBoxes and functions

Branching and looping

  • The IF block
  • Using IF…ELSE…END IF
  • Select case
  • Using SELECT CASE to test a single conditional against multiple outcomes
  • Using Loops, DO…LOOP

Object Variables and FOR EACH… NEXT loops

  • Using object variables
  • Using the UNION function and multiple object variables

This course is available as a private or customised course. Contact us for further information and to customise this course to your exact requirements:

Phone us: 0208 269 4260Book Now


"Trainer's knowledge was immense, clearly an experienced practitioner."

Joseph Chamberlain College

"Very thorough course and enthusiastic trainer who was very helpful and responsive to individual needs."

NVIDIA

"Informative, educational and well delivered."

Ernst & Young



© Transmedia . 85 Tottenham Court Road, London, W1T 4TQ  UK . 0208 269 4260