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

City University London

Short course

In Islington

Price on request

The best Visual Basic courses

See all

See all

Description

  • Type

    Short course

  • Location

    Islington

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 3 October 2016 18:30 - 20:30 10 weekly classes £540.00 CS1595 Apply Now Tuesday 4 October 2016 18:30 - 20:30 10 weekly classes £540.00 CS1595 Apply Now Saturday 8 October 2016 10:30 - 16:30

(includes 1-hour break) 5 weekly classes £540.00 CS1595 Apply Now Monday 16 January 2017 18:30 - 20:30 10 weekly classes £540.00 CS1595 Apply Now Tuesday 17 January 2017 18:30 - 20:30 10 weekly classes £540.00 CS1595 Apply Now Saturday 21 January 2017 10:30 - 16:30

(Includes 1-hour break) 5 weekly classes £540.00 CS1595 Apply Now Monday 8 May 2017 18:30 - 20:30 10 weekly classes £540.00 CS1595 Apply Now Tuesday 2 May 2017 18:30 - 20:30 10 weekly classes £540.00 CS1595 Apply Now Saturday 6 May 2017 10:30 - 16:30

(Includes 1-hour break) 5...

Facilities

Location

Start date

Islington (London)
See map
Northampton Square, EC1V 0HB

Start date

On request

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Excel
  • Basic
  • Visual Basic training
  • IT
  • Basic IT training
  • Basic IT
  • Visual Basic
  • MS Excel

Course programme

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.

Additional information

Teaching and Assessment

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

See related categories

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

Price on request

The best Visual Basic courses

See all

See all