Study at City
  1. Courses
  2. Applying
  3. Fees and funding
  4. Living in London
  5. Visit us
  6. Student support
  7. International students
  8. Order a prospectus
  9. Ask a student
  1. Short courses
  2. Courses
Study at City

Visual Basic for Applications (VBA) in Excel | Part 1 Short Course

Key information

Choose a start date
Days:
To be confirmed
Duration:
To be confirmed
Time:
To be confirmed
Fees:
To be confirmed
Course Code:
To be confirmed
Location:
To be confirmed
Booking Deadline:
To be confirmed
To be confirmed

City is one of the very few universities in London offering this short course, which teaches you how to automate Excel so that even very complex functions can be achieved quickly and simply.

Why choose this course?

Using a step-by-step approach, this highly popular course shows how the Visual Basic for Applications (VBA) programming language can extend the functionality of Excel. It is ideal for those who work with Excel and need to manipulate and analyse data.

This practical course can be taken on weekday evenings or daytime Saturday, at our Central London location.

Course overview

You will learn to write macros to accept user input, read to and write from cells and manipulate data. You will also learn to write custom functions and create user forms. Useful examples of problems and their solutions are provided.

This short course is ideal for those with a good knowledge of MS Excel and would like to add additional functionality. No programming knowledge is required.

  • “ Perfect level and breadth of information ”

    Andrew Johnson

    Former student

  • “ An enjoyable course which helped me gain the skills I signed up for ”

    Lucy Briggs

    Former student

What will I learn?

What will I learn?

  • Recording and running macros
  • Assigning macros to menus, toolbars and buttons
  • The Visual Basic editor
  • Input boxes and Message boxes
  • Object-oriented concepts: objects, properties, methods and events
  • Excel objects
  • Variables and constants
  • If statements
  • Looping
  • Conversion functions
  • User-defined functions
  • User forms and dialog boxes
  • Error-handling and debugging
  • Workbook and Worksheet events

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

  • Record and run macros
  • Use the Visual Basic environment to edit programs
  • Write Visual Basic code, using variables, loops and if statements
  • Understand Excel VBA functions and write their own functions
  • Understand and apply object-oriented concepts
  • Be acquainted with the most important Excel VBA objects and properties
  • Understand events in Excel
  • Debug (i.e. correct) errors.

Eligibility

Eligibility

Prerequisite knowledge

Strong knowledge of MS Excel, otherwise delegates are having to learn Excel as well as VBA. Delegates should be able to:

  • Comfortably use separate worksheets
  • Add/delete columns and rows
  • Basic formatting of spreadsheets.
  • Use formulas and basic functions including IF() and ideally VLookup() and or CountIf()

Our Applied MS Excel for Business is a good grounding for this.

English requirements

You must have proficient written and spoken English.

Teaching & assessment

Teaching & assessment

Informal assessment will take place through group discussion, class room activities, and questions and answers sessions as guided by your tutor.

Tutor information

  • Sean Walsh

    Sean Walsh has over 10 years’ experience of Excel and VBA.  He was a member of the Support, Training and Documentation team within City’s IT department and has an MSc in Computing Science from Birkbeck.

    Sean has taught other evening classes for City such as Oracle and SQL, XML, Excel and MS Office. He has also managed an academic programme within City, University of London’s Continuing Education department.

Next steps

This Visual Basic for Applications (VBA) in Excel Part 2 evening Short Course further develops your VBA programming knowledge with the introduction of a wider range of objects.…