Arrays in Visual Basic for Application are structures that typically store collections of related variables of the same type. The array records are accessed by their numeric index. For example, there is a team of 20 people whose names need to be saved for later use in VBA code. One could simply declare 20 variables to hold … Read more
In VBA, as in any other programming language, variables and constants are used to store values. As the name suggests, variables can change, while constants store fixed values. For example, the constant Pi stores the value 3.14159265 … The number “Pi” will not change during program execution, but it is still more convenient to store such a value … Read more
When starting to practice writing VBA code, it is very important to develop good coding habits from the very beginning so that later on the written code is easy to read and understand how it works. In the process of writing code, a programmer can have a very clear idea of what kind of code … Read more
We all have – some less often, some more often – to repeat the same actions and operations in Excel. Any office work involves some kind of “routine” – the same weekly reports, the same actions for processing incoming data, filling out monotonous tables or forms, etc. The use of macros and user-defined functions allows you to … Read more
The self-tutorial was created especially for beginner Excel users, more precisely for “complete figures”. Information is given in stages, starting from the very beginning. From section to section of the tutorial, more and more interesting and exciting things are offered. After completing the entire course, you will confidently apply your knowledge in practice and learn how to work … Read more