A collection is a stack of objects of the same type, “chained” one after the other.
As you add an object to the collection, it assumes the next index in sequence – added as the next “link” in the “chain”.
The collection is an easy to use data structure. It requires no declaration of the anticipated size of the “chain” in advance....
Simply put, enumeration is about naming sets of related constant numbers.
You probably already worked with enumerations. For example, the Application.Calculation property is numeric. It holds a number representing the calculation mode of Excel. Possible values for this property are:
In Part 1 on this exercise of implementing OOP in Excel VBA, we left off with a half-baked order object. It had some properties and a couple of methods, but its line-items were missing.
Today we’re going to round up our order object to include its line-items.
Thinking about the right structure and arrangement of the line-items within the order object, two main characteristics should guide our thinking:
After we covered in detail what OOP is in last week’s Blog post, we’re ready to see how this works in Excel VBA.
The key concept to keep in mind as we implement objects in Excel VBA, is that we are creating our own custom objects, on top of the available objects at our disposal out of the box.
The image here shows a list of the available properties and methods of the Workbook object.
This list is the exposed interface of the...
In order for you to understand this article, you need to know what an Object in computer programming is. Lucky for you, I just wrote about it last week.
There are two dominating programming paradigms out there.
The basic concept is that of statements organized in modules and functions, executed in order.
Typically, there is a main...
Simply put, an object is any “thing” you can actually see, physically.
For example, a person, a car, a pencil, a circle – are all physical objects.
Extending our perception of object to understand how objects are used in computer programming, an object can also offer a well-defined service: A Government...
In one of my customer’s project that manages trainings and certifications, employees receive email and SMS notifications on various events: upcoming training reminders, training result (with a certificate attached), change of instructor, training assessment reminders etc.
The technique for doing that is using a queue. All notifications...
In my Blog post from last week In which I elaborated on writing VBA code that runs on both Office 32-bit and Office 64-bit, we ended up with a challenge. We need to include the PtrSafe and LongPtr qualifiers in external libraries declarations for Office 64-bit, but ignore these qualifiers in Office 32-bit environments (where they are unknown).
Today I’ll explain all about VBA’s pre-compiler...
In last week’s Blog post, I explained and demonstrated how Windows functions libraries, or DLLs, can be called from VBA.
Leveraging external functions to Excel is great, especially considering the vast variety of functions the Windows operating system offers. However, breaking the tight Excel environment is also subject to some compatibility issues.
As you recall from our computer programming lessons, one of the key concepts in good software design is modularity: breaking our code into functional subroutines or functions, each responsible for a specific task with a clear interface for calling it.
Once encapsulated in a self-contained function, this functionality can be re-used in many locations in your program....