My restraint is due to my being on painkillers.
In addition to looking at examples of sorting code, the poster could look at
the Sort Performance Comparison Program at
http://www.standards.com/Sorting/SortPerformanceComparison-Description.html.
IMHO, there's nothing wrong with use a "brute force" algorithm the first
time around. It takes time to earn how to improve algorithms or to find
better prepublished algorithms. In many cases, algorithms published in
VB/VBA books are not so desirable.
In addition the particular coding techniques can make an enormous
difference. For example, looking to the future, using the Stringbuilder
class in VB .NET is more than 800 times faster than do the typical string
concatenation of, say, x = x +"A". One example I ran was 852 times faster.