Reference
Source inventory
The public API and source layout of VBA-DataKit.
3 utility classes26 public procedures6 enumerations
Modules#
| Class | Public procedures | Source |
|---|---|---|
| Arrays | 17 | View source |
| Finance | 6 | View source |
| Others | 3 | View source |
Shared instances#
For convenient calls from standard modules, create these shared instances once in your VBA project:
Public Arr As New Arrays
Public Fin As New Finance
Public Others As New OthersAPI reference#
The full function list is available on each class overview: Arrays, Finance and Others. See enumerations for named comparison, grouping and selection operators.
Dependencies#
Arrays.Unique and Arrays.GroupBy use Scripting.Dictionary. Enable Microsoft Scripting Runtime in the VBA project's references. Excel object types require the Excel host.