Course code: VSBFB
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.
Professional
and certified lecturers
Internationally
recognized certifications
Wide range of technical
and soft skills courses
Great customer
service
Making courses
exactly to measure your needs
Starting date: 02.12.2024
Type: In-person/Virtual
Course duration: 5 days
Language: en/cz
Price without VAT: 960 EUR
Starting date: 13.01.2025
Type: In-person/Virtual
Course duration: 5 days
Language: en/cz
Price without VAT: 960 EUR
Starting date: 03.03.2025
Type: In-person/Virtual
Course duration: 5 days
Language: en/cz
Price without VAT: 960 EUR
Starting date: 26.05.2025
Type: In-person/Virtual
Course duration: 5 days
Language: en/cz
Price without VAT: 960 EUR
Starting date: 28.07.2025
Type: In-person/Virtual
Course duration: 5 days
Language: en/cz
Price without VAT: 960 EUR
Starting date: 08.09.2025
Type: In-person/Virtual
Course duration: 5 days
Language: en/cz
Price without VAT: 960 EUR
Starting date: 03.11.2025
Type: In-person/Virtual
Course duration: 5 days
Language: en/cz
Price without VAT: 960 EUR
Starting date: Upon request
Type: In-person/Virtual
Course duration: 5 days
Language: en/cz
Price without VAT: 960 EUR
| Starting date |
Place |
Type | Course duration |
Language | Price without VAT | ||
|---|---|---|---|---|---|---|---|
| 02.12.2024 | In-person/Virtual | 5 days | en/cz | 960 EUR | Register | ||
| 13.01.2025 | In-person/Virtual | 5 days | en/cz | 960 EUR | Register | ||
| 03.03.2025 | In-person/Virtual | 5 days | en/cz | 960 EUR | Register | ||
| 26.05.2025 | In-person/Virtual | 5 days | en/cz | 960 EUR | Register | ||
| 28.07.2025 | In-person/Virtual | 5 days | en/cz | 960 EUR | Register | ||
| 08.09.2025 | In-person/Virtual | 5 days | en/cz | 960 EUR | Register | ||
| 03.11.2025 | In-person/Virtual | 5 days | en/cz | 960 EUR | Register | ||
| Upon request | In-person/Virtual | 5 days | en/cz | 960 EUR | Register | ||
| G | Guaranteed course | ||||||
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.
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
