Tag: VBA

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 […]