Blog posts

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

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

Sep 12, 20236 min read

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?

Aug 31, 20233 min read

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 28, 20233 min read

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

Jul 25, 20232 min read

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

Articles: Blog2