Tutorial


VBA Class Variables Private and Public variables Classes are datatypes. A class is a special datatype because it can contain both variables and routines. The variables can be Private or Public. By default, variables in a class should be Private. Private variables can only be used by the routines of […]

VBA Class: Variables


VBA Class Routines Private and Public routines Classes are datatypes. A class is a special datatype because it can contain both variables and routines. The routines can be Private or Public. For routines, there is no default. Private routines can only be used by the other routines of the class […]

VBA Class: Routines


VBA Class Destroy It is good practice to destroy a class instance that is no longer needed. [crayon-5fbcfdba7f2e2202966092/] By Set Logger = Nothing the object reference that is assigned to the variable is released. Now, the variable can be go out of scope safely. The sub Class_Terminate The sub Class_Terminate […]

VBA Class: How to destroy



VBA Class Create Declaration To create an instance of a class, two lines of code are needed. Say the name of the class is cLogger. [crayon-5fbcfdba7f5ba105351599/] The first line declares a variable of the type cLogger. The second line assigns an object reference to the variable. Now, the variable is […]

VBA Class: How to create


General You want to use classes in VBA? Seriously? Let's be clear from the start: VBA is not the most advanced programming language in the world. There are many programming features that VBA does not support, and that are considered common good in other programming languages. For instance, there are […]

VBA Class: Introduction


General Imagine a set that contains all the characters of all known languages, of all traditions of all times, past and present. The UCS and the Unicode set Two organizations have made (and are making) the effort to build such a set. The first organization is the International Organization for […]

VBA String



General What does the value null mean? In the context of data, when a field has the value null, it means that we don't know the value for the field. null represents the absence of a value, whatever the type of the field (numeric, text, ...). Only optional fields can […]

VBA Null



Imagine a set that contains all the characters of all known languages, of all traditions of all times, past and present. The UCS and the Unicode set Two organizations have made (and are making) the effort to build such a set. The first organization is the International Organization for Standardization […]

VBA Strings used in JSON