Visual Basic for Applications (VBA) in Excel Part 1

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.

On this Excel VBA training course 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 VBA training course is ideal for those with a good knowledge of MS Excel and would like to add additional functionality. No programming knowledge is required.

City St George’s is one of the very few universities in London offering this short course. Work more efficiently and save time by learning these vital VBA skills.

Who is it for?

This course is ideal if you work with Excel and need to manipulate and analyse data.

Timetable

VBA Part 1 takes place one evening a week for 10 consecutive weeks.

City St George’s Short Courses follow the academic year, delivering courses over three terms. These include:

• Autumn - October
• Spring - January
• Summer - April

Benefits

• Delivered by an industry professional
• Taught in small groups
• Awarded a City St George’s, University of London certificate

• 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.

You will be awarded an official City St George’s, University of London certificate if you attend over 70 per cent of the classes. The course is not formally accredited.

Assessment

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

You should have a strong working knowledge of MS Excel to enrol on this course.

You 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

Applicants must be proficient in written and spoken English.