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

Using a step-by-step approach, this course shows how the Visual Basic for Applications (VBA) programming language can extend the functionality of Excel. Students learn to write macros to accept user input, read to and write from cells and manipulate data. They also learn to write custom functions and create user forms. Useful examples of problems and their solutions are provided.

Course Information

Start DateStart TimeDurationCostCourse CodeApply
Monday 2 October 2017 18:30 - 20:30 10 weekly classes £560.00 CS1595 Course Full
Tuesday 3 October 2017 18:30 - 20:30 10 weekly classes £560.00 CS1595 Course Full
Saturday 7 October 2017 10:30 - 16:30
(includes 1-hour break)
5 weekly classes £560.00 CS1595 Course Full
Saturday 11 November 2017 10:30 - 16:30
(includes 1-hour break)
5 weekly classes £560.00 CS1595 Apply Now
Monday 15 January 2018 18:30 - 20:30 10 weekly classes £560.00 CS1595 Apply Now
Tuesday 16 January 2018 18:30 - 20:30 10 weekly classes £560.00 CS1595 Apply Now
Saturday 20 January 2018 10:30 - 16:30
(Includes 1-hour break)
5 weekly classes £560.00 CS1595 Apply Now
Monday 30 April 2018 18:30 - 20:30 10 weekly classes £560.00 CS1595 Apply Now
Tuesday 1 May 2018 18:30 - 20:30 10 weekly classes £560.00 CS1595 Apply Now
Saturday 5 May 2018 10:30 - 16:30
(Includes 1-hour break)
5 weekly classes £560.00 CS1595 Apply Now

Tutor Info

Sean Walsh has over 10 years’ experience of Excel and VBA.  He was a member of the Support, Training and Documentation team within City University University’s IT department and has an MSc in Computing Science from Birkbeck. He has taught other evening classes for City University such as Oracle and SQL, XML, Excel and MS Office. He has also managed an academic programme within City University’s Continuing Education department.

Eligibility

Strong knowledge of MS Excel.

English Requirements

Applicants must be proficient in written and spoken English.

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.

Teaching and Assessment

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

Application Deadline: