VBA-utilities is a collection of helpful modules for programming in VBA. It is important to note, these modules are all programed using the Option Base 0 and Option Compare Text settings.

This section lists each of the modules along with a brief description of their purpose.

The Arrays module contains various methods for manipulating arrays in VBA, e.g. copying and sorting. The Arrays module requires the IVariantComparator module be loaded. Useage example: an array A() can be sorted using the following method call

Arrays.sort A()

If using a custom IVariantComparator, the order of elements can be customized.

The Arrays.copyOf method produces a 1D copy of the entire original array, and the Arrays.copy method copies a subrange of the source array, src to the destination array, dest

The Collections module contains various methods for manipulating collections in VBA. Specifically, the module provides methods to check if a collection contains a specific element and also to retrieve its index, and to sort a collection (requires the Arrays and IVariantComparator modules to be loaded). For a collection col, the following is a list of example method calls:

Dim bVal1 As Boolean
bVal1 = Collections.contains("hello world", col)

Dim bVal2 As Boolean
bVal = Collections.hasKey(5, col)

Dim iVal As Long
iVal = Collections.indexOf("hello world", col)

The sort method for the Collections module

Collections.sort col