Blog posts

Often, especially when creating text to show to a user in a dialog, I have a Collection or Array of Strings that I want to use to inform the user of some information. Code to compile those Strings into "clean" user-friendly text can be a pain to write ... for example, making sure the penultimate and last items are delimited by "and" instead of a comma especially when you don't know how many Strings will be included from the off.

The standard VBA.InputBox (and Application.InputBox, available if working in Excel) only allow you to enter a single line of text. What to do if you want to allow a user to enter multiple lines of text? Use a UserForm with a multiline TextBox ...

Interpolation means 'inserting one thing into another'. In this case, inserting one (or more) 'sub' Strings into another 'main' String.

Get the name of an Enum member, not its value using the 'Add a "GetEnumAsString()" function' ... automatically added by VBE_Extras.

VBE_Extras includes functions for 'Matches for literal value at cursor' and 'Extract to constant' which are closely related.

This is an implementation of the 'merge sort' algorithm - one of the most efficient sorting algorithms. It uses what's known as a 'divide...