EXVBA-1
Excel programming in Visual Basic basics
Trainer recommendation
Horváth Elek trainer
If someone asked me what I most enjoy teaching, I’d say VBA—or macro writing. A spreadsheet program is fantastic on its own, but everyone should explore the extra value that Visual Basic can bring, especially if you’re serious about mastering all the intricacies of Excel. Not to mention, VBA is also a great entry point into understanding programming in general. So I can confidently say this training offers multiple benefits.
Description
The aim of the course is to introduce users, future developers and programmers with little or no programming experience to Visual Basic for Applications / VBA, its basic concepts and basic programming elements, and its basic use in MS Office environment.
The course is not intended to train Visual Basic programmers, the emphasis is on familiarising them with the VBA environment, writing (fixing) and modifying simple programs. At the end of the course, students will have a general knowledge of programming, which can be used to program VBA in Office products, among others.
Outline
Introduction
- What are fixed Macros and VBA codes?
- File formats and how Macros are stored and run
- Setting the program environment
- Macro protection settings and possible threats
- Fixing simple macros
Overview of the Visual Basic for Application programming environment
- Parts of the development environment, structure, protection settings
- Basic tools and functions
Programming basics
- Overview of the VBA language, syntax, general knowledge
- Constants, variables, variable declarations (number, string, other
- Basic statements and their use
Types of conditional branches and their use
- One-way branching
- Multi-directional branching
- Nested forks
Types of cycles and their use
- Counting cycle
- Forward testing cycle
- Back test cycle
- Collection (object) entry loop
Overview of Office objects and object models
- Technological background
- Working with objects in collections (workbook, worksheet, domain, cell)
- Properties and methods
Writing and testing simple programs
- Applying what you have learned to simple example programs
- Compiling and running a program
- Debugging a program, detecting and correcting program errors
- Eliminating common errors
- Saving a program
Prerequisites
Windows and information technology skills. Knowledge of the Excel Advanced course material, with practical experience of the topics covered. Due to the difficulty of the course, basic programming skills and Access user skills are an advantage to effectively master the material and perform data management tasks.