Blog posts

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 15, 20234 min read

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

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

May 23, 20236 min read

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

Apr 20, 20231 min read

Adding a Button to the Ribbon menu is surprisingly easy. If you follow this post, you will end up with both a Button and a ComboBox.

Apr 12, 20239 min read

Programmatically adding controls to a UserForm and reacting to their events

Mar 31, 20235 min read

Get fed up with the boring default colours available in the VBE's 'Options' dialog? Don't like cyan text on a magenta background ... make...

Mar 22, 20231 min read

It's taken me 3 months (Access is so, so different to other Office applications!) but VBE_Extras now works from the VBE hosted by...

Mar 10, 20231 min read

Something that brings a UserForm to life is, when the mouse pointer hovers over a Button, there's an indication that the Button is clickable

Mar 8, 20233 min read

Update October 2024: This post uses Visual Studio and/or RegAsm to 'statically' register your C# library before it is loaded and used by...

Feb 24, 202323 min read

Articles: Blog2