MS Word
MS Excel
MS PowerPoint
MS Access
MS Publisher
MS Project

Microsoft VBA Courses

Overview

Harness the true power of Microsoft Applications. by learning Macros and programming code you will be able to automate repetitive tasks and to manipulate the programs in a very controlled and secure way that may not be possible through the standard menus. These 2 day course will give delegates everything they need to write efficient effective programming code, with plenty of samples to take away.

Available Course Levels

EXCEL VBA INTRODUCTION

This course introduces delegates to the Visual Basic ‘behind the scenes’ programming code that controls Excel. Learn how to write good quality code automate Excel or to solve and simplify more complex problems. We will look how to build user forms that allow you to more accurately control collection and analysis of data.

Delegates must have a good working knowledge of Excel to advanced level.

Topics

  • Introduction to VBA/macros
  • Recording VBA code (macros)
  • Awareness of settings
  • Absolute and relative modes
  • Running code from buttons and toolbars
  • Using the Visual Basic editor
  • The code window and project explorer
  • Sub procedures
  • Visual Basic language key points
  • Objects, properties, methods and events
  • Working with cells, ranges, values and text
  • Controlling objects and their properties
  • Performing actions with methods
  • Defining constants variables and arrays
  • Using data in VBA
  • Calling sub procedures
  • Auto-run procedures
  • Debugging code and correcting errors
  • Adding watches
  • Using the immediate window
  • Stepping through code
  • Creating and reusing functions

EXCEL VBA INTERMEDIATE

Although the intro level course gives delegates the knowledge to record macros and write simple VBA procedures, the aim of this course is to be able to solve more complex Excel tasks using powerful VBA techniques and to be able to use VBA to integrate Excel with other Office applications.

NB this course is ONLY run as a continuation of the Excel VBA intro level course, All delegates need to have completed the intro level VBA course first

Topics

  • Recap of basics
  • Import and export using text files
  • Importing from multiple Excel files
  • Linking with Microsoft Access
  • Linking with Microsoft Word
  • Creating document management systems
  • Optimising code
  • Improving Excels inbuilt tools
  • Referencing variables between workbooks
  • Object variables
  • Arrays and 3 dimensional arrays
  • Type conversion functions
  • Advanced text manipulation
  • Creating add-ins
  • Class modules
  • Using and creating activex controls

ACCESS VBA INTRODUCTION

This 2 day programming course will introduce delegates to the extremely powerful tools of VBA within Microsoft Access. Learn how to use Programming code to automate time consuming and repetitive tasks, customise many different parts of a database, learn how to use VBA to improve the flow of data and to secure a database using programming code.

Prerequisites: delegates must have attended the ‘Access Advanced Level’ training course prior to this VBA course.

Topics

  • Introducing VBA programming
  • The programming environment
  • Project explorer
  • Understanding procedures
  • Creating a sub procedure
  • Creating a function procedure
  • Working with code to use input and message boxes
  • Decision making code
  • Testing code using the debug tools
  • Understanding Objects, Properties, Methods and Events
  • Using inbuilt Functions and Constants
  • Declaring and using variables
  • Message boxes and Input Boxes
  • Various types of decision making structures
  • Creating Record sets via code
  • Using VBA to process SQL statements
  • Error trapping principles

Microsoft Word

Microsoft Excel

Microsoft Access

Microsoft PowerPoint

Microsoft Publisher

Microsoft Project

Microsoft Visio

Microsoft VBA