Course code: MSVBA1« Back

Introduction into Visual Basic for Applications (VBA)

In this course, you get the basic skills to develop applications using Visual Basic for Applications (VBA), which is used primarily for the development of macros in MS Office. You will learn how to use basic construction of Visual Basic, define variables, use data types, functions and procedures, and collections, loops, you learn to handle runtime errors application debug program, use their own forms and also understand the basics of object-oriented programming. To attend the course requires basic knowledge of algorithms and programming course at PRG.

 DateDurationCourse priceHandbook priceCourse languageLocation 
GTK 10/14/2019 5 22 500 CZK included in course price Český jazyk GOPAS Praha
 
2/17/2020 5 22 500 CZK included in course price Český jazyk GOPAS Praha
 
4/20/2020 5 22 500 CZK included in course price Český jazyk GOPAS Praha
 
10/21/2019 5 22 000 CZK included in course price Český jazyk GOPAS Brno
 
3/9/2020 5 22 000 CZK included in course price Český jazyk GOPAS Brno
 
GTK 11/18/2019 5 750,00 EUR included in course price Slovenský jazyk GOPAS Bratislava
 

AffiliateDurationCatalogue priceHandbook priceITB
Praha5 22 500 CZK included in course price 50
Brno5 22 000 CZK included in course price 50
Bratislava5 750,00 EUR included in course price 50

What we teach you:

  • Using variables and data types.
  • Create functions and procedures
  • Use basic language constructs such as conditions and cycles
  • Debug application
  • Capture runtimeove errors
  • Create your own forms and use controls
  • Much more practical and useful techniques that you use in your applications

Required skills:

  • Knowledge of algorithms and programming at the level of the course PRG.

Teaching methods:

  • Professional explanation with practical samples and examples.

Teaching materials:

  • Powerpoint handouts and module printouts.

Course syllabus:

Introduction to create applications using Microsoft Visual Basic

  • Properties of Microsoft Visual Basic
  • Working in a development environment

Working with program code

  • Modules
  • Using the editor window
  • Comments
  • Environment settings
  • Automatic code completion
  • Dialogs

Variables and Procedures

  • Declaring variables
  • Data types
  • Converting Data Types
  • Constants
  • Arrays

Procedures and Functions

  • Procedures and Functions
  • Parameters of functions and procedures
  • Optional parameters
  • value parameters and reference parrameters
  • Featured built-in functions

Flow control program

  • Logical and comparison operators
  • If..Then
  • Select..Case
  • Do..Loop
  • For..Next
  • Ending loops

Working with collections

  • What's Collection
  • Create a collection
  • Passage through the collection cycle For..Next
  • Passage through the collection cycle For..Each
  • Samples collections

Debugging

  • Types of errors
  • Watch window
  • Immediate window
  • Call Stack
  • Locals window
  • Step through the program

Catching errors

  • Run-time error
  • Err object
  • Concatenation errors
  • Inline Error Handling

Basics of creating custom forms

  • Custom forms
  • Basic usage controls

Object-oriented programming

  • Introduction to Object
  • Use the properties, methods and events
  • Create and use custom classes
  • Create and use custom properties
  • Creating and using custom events
Tištěné prezentace probírané látky

Price:
included in course price
The prices are without VAT.