by mor | Oct 22, 2020 | Blog
A collection of variables of the same data type is a very efficient data structure and easy to work with. Did you know that you can also define your own custom collections? Here is how! What is a collection? A collection is a stack of objects of the same type,... 
by mor | Oct 15, 2020 | Blog
Leveraging the nature of numbers storage in memory, we can exploit enumerators to construct complex Boolean expressions in near-English language. This post will change the way you handle multiple-choice questions. Last week we introduced Enumerations and how they make... 
by mor | Oct 8, 2020 | Blog
Instead of remembering numeric codes – label them with meaningful words. This way your code will flow from your fingers just as you speak, and your program will be clear and readable. Let us understand enumerations. What are Enumerations? Simply put, enumeration is... 
by mor | Oct 1, 2020 | Blog
Prompt the user for required input, using an easy to interact with input box in your Excel VBA program. All you need to know about the InputBox function is right here. Oh, do not forget to validate! What is an InputBox and When to Use It In last week’s Blog post I... 
by mor | Sep 24, 2020 | Blog
Show informative, easy to interact with messages to your Excel VBA program users. All you need to know about the MsgBox function is right here. Read on… User interaction is a big deal Why? Because this is where your program meets the psyche, mindset, values,... 
by mor | Sep 17, 2020 | Blog
In this Blog post I cover all ways and tips for using color codes in your Excel VBA program. Discover how to store colors as constants, identify the code of any color and apply colors to any Excel object. Understanding Color Codes Every color is identified by a unique... 
by mor | Sep 10, 2020 | Blog
In this advanced chapter of OOP with Excel VBA, we implement objects composition with a dynamic collection in Excel VBA using Class Modules. Not for the faint of heart… In Part 1 on this exercise of implementing OOP in Excel VBA, we left off with a half-baked order... 
by mor | Sep 3, 2020 | Blog
Ever wanted a concise, clear with code examples guide to implement OOP in Excel VBA? It is your lucky day. Read on… 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. Keep your eyes on the Object The key... 
by mor | Aug 27, 2020 | Blog
If we live in a world of objects and our computer programs help us manage our world, how about representing the world’s objects in our computer programs! * Object Oriented Programming explained In order for you to understand this article, you need to know what an... 
by mor | Aug 20, 2020 | Blog
Objects are a key element in computer programming. While objects are at center stage in Object Oriented Programming, they are widely used in procedural languages and serve as the building blocks of complete applications * Let’s understand objects! What is an Object?...
Recent Comments