Excel VBA: Collections

Excel VBA: Collections

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,...
Excel VBA: Bit-Wise Enumerations

Excel VBA: Bit-Wise Enumerations

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...
Excel VBA: Enumerations

Excel VBA: Enumerations

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...
Excel VBA InputBox Explained

Excel VBA InputBox Explained

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...
Excel VBA MsgBox Explained

Excel VBA MsgBox Explained

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,...
Working with Colors in Excel VBA

Working with Colors in Excel VBA

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...
Object Oriented Programming with Excel VBA – Part 2

Object Oriented Programming with Excel VBA – Part 2

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...
Object Oriented Programming with Excel VBA – Part 1

Object Oriented Programming with Excel VBA – Part 1

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...
Understanding Object Oriented Programming

Understanding Object Oriented Programming

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...
Understanding Objects in Computer Programming

Understanding Objects in Computer Programming

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?...