Tag: array

VBA ParamArray
Excel, MS Office, Outlook, PowerPoint, Tip of the Day, Word

The VBA ParamArray for a dynamic list of VBA arguments

Today’s VBA Tip of the Day concerns dynamic parameter declaration via the VBA ParamArray. When declaring Functions/Procedures in some cases you may need to specify Optional arguments. Let’s say we want to write a procedure that works similarly as other procedures you know natively from Excel like SUM: Now how would you create such a […]

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