Procedures in VBA are a set of instructions designed to perform a specific task. The purpose of creating a procedure is to better organise code, improve readability, and enable the…
In the previous lessons, we explored variables and how to declare them in VBA. In this section, we’ll discuss the concept of a Constant and see why and how you…
In the previous tutorial, we learnt how to declare variables. In this part of the free VBA training series, we’ll explore the concept of Variable Scope and how it defines…
If you have ever written code in VBA, you have certainly come across the term Module. But what exactly is a module, and how does it differ from a class?…