Visual Basic for Applications (VBA) in Excel - Introduction to programming Training Course

Primary tabs

Course CodeCourse Code

vbaexcel

Duration Duration

28 hours (usually 4 days including breaks)

Requirements Requirements

Ability to work with a spreadsheet, basic knowledge (references, ranges, sheets, ...). Knowledge is no required to create new macros or VBA code. The course is a gentle introduction to programming problems and automate tasks in Excel.

Overview Overview

It is an introduction to procedural programming in VBA. Training allows you to gain a strong foundation for further learning and VBA environment.

After the course you can:

  • Record and edit the macro as required,
  • Write procedures using data from the sheet,
  • Create your own functions
  • Handle the event (opening worksheet cell update etc) by means of the handler,
  • Create form

Course OutlineCourse Outline

Macros

  • Recording and editing macros
  • Assigning macros to forms, toolbars, keyboard shortcuts

VBA Environment

  • Visual Basic Editor and its options
  • Management components
  • Keyboard Shortcuts
  • Optimizing the environment

Introduction to procedural programming

  • Procedures: Function Sub
  • Data types
  • The if statement ... then ... elseif ... else ... end if
  • Case statement
  • Loops for ... loop while, until
  • Loop for ... next
  • Instructions loop break (exit)
  • Array processing

Quoted string

  • Combining quoted strings (concatenation)
  • Conversion to other types of (implicit and explicit)
  • Features processing quoted strings

Visual Basic

  • Download and upload data to a spreadsheet (Cells, Range)
  • Download and upload data to the user (InputBox, MsgBox)
  • The declaration of variables
  • The extent and lifetime of variables
  • Operators and their priorities
  • Options modules
  • Create your own functions and use them in a sheet
  • Objects, classes, methods and properties
  • Securing code
  • Security code tampering and preview

Debugging

  • Processing step
  • Locals window
  • Immediate window
  • Traps - Watches
  • Call Stack

Error handling

  • Types of errors and ways to avoid
  • Capturing and handling run-time errors
  • Structures: On Error Resume Next, On Error GoTo

Excel Object Model

  • The Application Object
  • Workbook object and a collection of Workbooks
  • Worksheet Object and Collection Worksheets
  • Objects ThisWorkbook, ActiveWorkbook, ActiveCell
  • Object Selection
  • Collection Range
  • Object Cells
  • Display data on the status bar
  • Optimization using ScreenUpdating
  • The time measurement by the method Timer

Event handling in VBA

  • What is an event?
  • Responding to an event and create an event handler
  • Triggering Event Handlers
  • Service frequently occurring events

VBA Forms

  • Create your own forms
  • Calling a form from code
  • Use the forms in the sheet

TestimonialsTestimonials

Exercises

Anna Szumniak - UBS Business Solutions Poland Sp. z o.o.

Training agenda was well thought out

Przemek Zalasinski - UBS Business Solutions Poland Sp. z o.o.

short excersises

Mateusz Podsiadlo - UBS Business Solutions Poland Sp. z o.o.

It was really nice from the trainer that he took a lot of time to answer our questions and helped us improve or gave us hints on how to improve some macros we were already using without fully understanding the code.

David Trieu - CD Projekt SA

A lot of exercise. Trainer doesn't need to have support for his course.
He has a really great knowledge for his subject.

Quentin Demeyere - UCB Pharma S.A.

Bookings, Prices and EnquiriesBookings, Prices and Enquiries

Private Classroom
 
Private Classroom
Participants are from one organisation only. No external participants are allowed. Usually customised to a specific group, course topics are agreed between the client and the trainer.
Private Remote
From 1980EUR
Private Remote
The instructor and the participants are in two different physical locations and communicate via the Internet. More Information

The more delegates, the greater the savings per delegate. Table reflects price per delegate and is used for illustration purposes only, actual prices may differ.

Number of Delegates Private Remote
1 1980EUR
2 1440EUR
3 1260EUR
4 1170EUR
Public Classroom
From 2780EUR
(67)
Public Classroom
Participants from multiple organisations. Topics usually cannot be customised

The more delegates, the greater the savings per delegate. Table reflects price per delegate and is used for illustration purposes only, actual prices may differ.

Number of Delegates Public Classroom
1 2780EUR
2 1890EUR
3 1593EUR
4 1445EUR
Cannot find a suitable date? Choose Your Course Date >>
Too expensive? Suggest your price

Related Categories

Related Courses


Upcoming Courses

VenueCourse DateCourse Price [Remote / Classroom]
Orléans, Central StationMon, 2017-11-06 09:301980EUR / 2780EUR
Poitiers, centre villeMon, 2017-11-06 09:301980EUR / 2780EUR
Grenoble, Near train stationMon, 2017-11-06 09:301980EUR / 2780EUR
Marseille, Prado QuarterMon, 2017-11-06 09:301980EUR / 2780EUR
Nantes, ZenithMon, 2017-11-06 09:301980EUR / 2780EUR

Course Discounts

Course Discounts Newsletter

We respect the privacy of your email address. We will not pass on or sell your address to others.
You can always change your preferences or unsubscribe completely.

Some of our clients