Blog posts

Multi-line input box

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 ...

Dec 43 min read

String interpolation

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

Apr 73 min read

Add a "GetEnumAsString()" Function

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

Jul 1, 20245 min read

Extract literal values (Strings, numerics, dates) to a constant in VBA

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

Jul 25, 20232 min read

Extract literal values (Strings, numerics, dates) to a constant in VBA

Sorting Strings in VBA

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

Jun 13, 20232 min read

Articles: Blog2