We would like to share some standard code that we use in Arixcel when developing VBA or VB6 applications. Here is the first one - a procedure for sorting a collection of custom objects. It uses one of the fastest sorting algorighms with the efficiency of n * ln(n) (which is the best theoretically possible efficiency for sorting).
Sub QuickSortSortableObjects(colSortable As Collection, Optional bSortAscending As Boolean = True, Optional iLow1, Optional iHigh1)
Dim obj1 ...

News of Excel programming