Tag: class

vba class
Excel, MS Office

VBA Class Tutorial

The VBA Class allows you to define your own objects with unique properties and methods in VBA. Classes in at the core of all Object Oriented Programming languages. Although we can argue how much is VBA actually an Object Oriented Programming language, there is no doubt that VBA allows you to create Classes similarly as […]

VBA Dictionary
Excel, MS Office, Outlook, PowerPoint, Word

VBA Dictionary – Using the VBA Dictionary. Key Value pairs

Visual Basic for Applications (VBA) facilitates many useful data structures – its not just VBA Arrays you can use. COM libraries provide additional data structures such as the VBA Dictionary, ArrayList, Queue, Stack or SortedList. But before we jump into explaining how these more complex data structures work and how to use them, let’s start […]