Microsoft VBA For Excel Part 1

Who is the course for?

The modular hands-on course is aimed at experienced Excel users who need to automate repetitive tasks and customise Excel. Participants will aquire a sound working knowledge of VBA, to develop and automate spreadsheet solutions. The modular design includes practical examples and case studies.

Is this course suitable for me?
Take the Skills quiz

Pre-requisites

This course assumes that you have an excellent knowledge on Excel. Previous programming experience is not required.

What are the objectives of the course?

By the end of the course, you will be able to:

• Record and run macros

• Edit VBA code to make macros more efficient

• Add user interaction to macros in the form of message boxes and input boxes

• Describe the Excel object model, including objects, properties and methods

• Apply decision making techniques and use loops to control macro behaviour

What does the course cover?

Overview of VBA: Programming basics; recording and running macros; reading, editing and interpreting code; variables and data types; different ways to run a macro; making the most of on-line help

Interactive Subroutines: Displaying message boxes and input boxes; using variables and constants; calling one procedure from another; passing variables; scope, visibility and lifetime of variables

Objects, properties and methods: An introduction to the Excel object model; working wth collections and containers; how to refer to object; selecting and manipulating ranges in VBA; interrogating and setting object poperties; using the Immediate window

Decision making and control structures: Making decisions with 'if' and select case; using loops and control structures

How long does this course last?

1 day