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

City University London
In Islington (Grossbritannien)

Preis auf Anfrage

Wichtige informationen

  • Short course
  • Islington (Grossbritannien)
  • Wann:
    Freie Auswahl
Beschreibung

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

Wichtige informationen
Veranstaltungsort(e)

Wo und wann

Beginn Lage
Freie Auswahl
Islington
Northampton Square, EC1V 0HB , London, Grossbritannien
Plan ansehen

Was lernen Sie in diesem Kurs?

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

Themenkreis

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.

Zusätzliche Informationen

Teaching and Assessment

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