Blog posts

Sep 21, 20231 min read

Mandelbrot Set viewer - VBA vs C#

Using the Mandelbrot Set to demonstrate the relative speed of using C# code via COM Interop from VBA.

Sep 15, 20231 min read

Unblock a file containing VBA code

Since mid 2022, files containing VBA code received over the internet or via email can be 'blocked' - preventing the VBA code from running.

Sep 12, 20236 min read

A better collection in VBA

Fed up with arrays and Collections (and Dictionarys and ArrayLists)? Try List, a better collection for VBA.

Aug 31, 20233 min read

A better Application.OnTime ... run your VBA code to the nearest millisecond (ish)

Application.OnTime is great if you want to call your procedure to the nearest second. What do you do if you want finer control than that?

Jul 28, 20233 min read

Multiple choice UserForm in VBA using a ComboBox

Multiple choice UserForm in VBA using a ComboBox - this UserForm allows a user to make a choice when there are more than just Yes/No or OK/C

Jul 25, 20232 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.

Jun 15, 20234 min read

Sorting Objects in VBA

Sorting arrays of Objects in VBA - any Objects, Worksheets, Documents, Slides etc or Objects defined by your own custom Class Modules

Jun 13, 20232 min read

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

May 23, 20236 min read

Making Ribbon controls dynamic

How to make Ribbon controls react to the state of a workbook, document or presentation. In this example, a Button and ComboBox is added.

Apr 20, 20231 min read

Using mouse clicks to navigate VBA code in the VBE

Jump to declarations, jump to references, jump to matching literal values, highlight declarations and references ... with your mouse

Articles: Blog2