Course Code

3089
 

     Duration

14 Hours
 
 

     Requirements

 

     Overview

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

 

     Course Outline

Facilities

  • 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

Loops

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

Debugging

  • 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


tips

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

Starts

 

Ends

 

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

Location


  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