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....
Last week we introduced Enumerations and how they make our lives easier when handling numeric sets of constants.
Today we’ll take it further by exploiting the Enumeration data structure to handle combinations of values.
The typical use case we’re addressing here, is when we have to handle multiple-choice variables that can hold any...
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 last week’s Blog post I covered in great detail the Excel VBA MsgBox function. I will not repeat how user interaction is incredibly important, but as you now know how to present informative messages to your user, sometimes you also need some input from the user to feed your program.
As you probably know, you can employ VBA User Forms for highly...
Because this is where your program meets the psyche, mindset, values, thoughts and habits of the user. Can you guess what those are?
If the user doesn’t feel “at home” with your application, he would not want to use it. The American science fiction writer, Larry Niven, captured the importance of the user experience beautifully:
“That's the thing about people who think they hate...
Every color is identified by a unique number. For example, 255 represents Red. 16774980 represent a specific cyan.
You can also convert any decimal number to its Hexadecimal representation (or Hex for short). For example, that cyan color number equals FFF744 in Hex representation (use any decimal to hex converter you find on the web to see how it works).
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...
Last week I offered some advice on improving the performance of your Excel Workbook. This week, we’ll improve your VBA code!
Most of the VBA code out there is a result of advanced Excel users who learned some VBA statements. They know how to reference Worksheet cells, how to run a loop and maybe manage multiple Workbooks and Worksheets.