Introduction to VBA

Course Dates: 31/03/19 - 07/04/19
Time: 10:00 - 17:00
Location: KS - Keeley Street
Tutor: Andrew Chu

Build on your advanced Excel skills and learn how to use the Visual Basic Editor (VBE) to create VBA procedures (macros) and user forms. You will then be able to modify and test these components easily step by step in the VBE.

View larger image

Introduction to VBA


What is the course about?

In this course, you will develop computer programming skills using Microsoft Excel and the Visual Basic for Applications (VBA) language. These programming skills can be used to tackle a wide range of real-world problems.

What will we cover?

Topic 1: Introduction to the VBA Environment
Topic 2: Data types & built-in functions in VBA
Topic 3: Modular programming I – Sub procedures
Topic 4: Modular programming II – Function procedures
Topic 5: Selective execution – If structures and Select Case structures
Topic 6: Repetitive execution – Loops
Topic 7: Arrays
Topic 8: Putting it all together.

What will I achieve?
By the end of this course you should be able to...

• Students will be able to input data and perform basic mathematical calculations within Excel spreadsheets.
• Students will be able to utilize fundamental programming concepts such as variables, modular programming, decision structures, repetitive structures, and arrays to develop VBA programs that manipulate Excel spreadsheets and perform basic calculations.
• Students will be able to comprehend the purpose and logic behind simple ready-made VBA programs, and will be able to predict the output of such programs.

What level is the course and do I need any particular skills?

- You should be at an Intermediate level in Excel
- No experience in computer programming required.

You should also be able to follow spoken and written instructions and be comfortable carrying out mathematical calculations.

How will I be taught, and will there be any work outside the class?

Each student has their own computer. Lectures will take place in the classroom, then exercises will be given to be completed as homework. We ll provide the solutions in the following class and tackle any challenging concepts.

Are there any other costs? Is there anything I need to bring?


When I've finished, what course can I do next?

Another Microsoft application course ie, Excel: financial modelling, Excel: analysing data.

General information and advice on courses at City Lit is available from the Student Centre and Library on Monday to Friday from 12:00 – 19:00.
See the course guide for term dates and further details


Customer Reviews 1 item(s)

Write a review
Good VBA starter course
Course Rating
Review by Anonymous / (Posted on 03/11/2018)

Book your place

Course Code: CEX26

Please choose a course date 

Sun, day, 31 Mar - 07 Apr '19

Duration: 2 sessions (over 2 weeks)

Full fee: £199.00
Senior fee: £159.00
Concession: £100.00

Or call to enrol: 020 7831 7831

Download form & post

Any questions?
or call 020 7492 2515

Please note: we offer a wide variety of financial support to make courses affordable. For more information visit our online Help Center. You can also visit the Information, Advice and Guidance drop-in service, open from 12 – 6.45, Monday to Friday.