Course Code



14 Hours




Course is intended for those familiar the basics of VBA who want to develop their knowledge and greater use of language capabilities.


     Course Outline


  • Create your own toolbar and menu

The data types

  • Conversion to other types
  • The extent and lifetime of variables
  • Operators and their priorities
  • Options modules

Conditional statements

  • Select Case
  • If ... Then ... ElseIf ... Else


  • When reversing loops
  • For Each loop
  • Instructions loop break (exit)


  • Processing step
  • Traps Watches
  • Locals Window
  • Immediate Window
  • Call Stack

Error handling

  • Capturing and handling run-time errors
  • Structures: On Error Resume Next, On Error GoTo label, On Error GoTo 0
  • Data display on the statusbar

Basic optimization

  • ScreenUpdating
  • Measurement of the duration of the macro by the method Timer

VBA Forms

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

     Feedback (9)

There was a good amount of information for the time of training. Also the trainer was very engaged with the group, especially when people were having troubles or asking questions. It was very nice of him to offer help in case of future ideas.

Aleksander Jarecki - Amazon Development Center Poland Sp. z o.o.

interesting and at the same time easy, absorbed way of presentation

Justyna Gutowska-Błaszyk

solving live problems (problems that participants had).

Dominik Gardo


Kamil Kowalski

a large variety of examples, transparent creation of forms step by step, efficiently conducted workshops despite the diversity of knowledge and skills of participants

Bogusia Kafel

The trainer prepared for training, specifically and on the subject

P4 Sp. z o.o.

Work on computers

P4 Sp. z o.o.

specific examples and adjusting the exercises to our needs

Marcin Gołdyn

practical examples

P4 Sp. z o.o.

The course could be tailored to suit your needs and objectives. It can also be delivered on your premises if preferred.



Online Price per participant 6000 AED


Classroom Price per participant 6000 AED





  Workday courses take place between 9:30 and 16:30


  Show venue details

Number of Participants

Related Courses

Total Courses 4

Access VBA

  21 hours

VBA For Access & Excel

  21 hours

Excel Advanced with VBA

  21 hours

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

  21 hours

Visual Basic for Applications (VBA) in Excel - Advanced

  14 hours

Visual Basic for Applications (VBA) for Analysts

  21 hours

Excel and VBA Programming for Audit and Finance Professionals

  28 hours


Analysing Financial Data in Excel

  14 hours


Excel For Statistical Data Analysis

  14 hours

Data and Analytics - from the ground up

  42 hours

Working with spreadsheet in Microsoft Excel

  14 hours

Discounted Public Courses

This site in other countries/regions