top of page
Blog posts
Search
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...
10 comments
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.
3 comments
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
0 comments
Apr 12, 20239 min read
Adding a Button (and a ComboBox) to the Ribbon
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.
0 comments
Mar 31, 20235 min read
Dynamically adding controls to a UserForm and reacting to their events
Programmatically adding controls to a UserForm and reacting to their events
0 comments
Mar 22, 20231 min read
Custom colours in the VBE
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...
0 comments
Mar 10, 20231 min read
VBE_Extras now available in Microsoft Access
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...
0 comments
Mar 8, 20233 min read
Changing UserForm Button colour on mouse hover
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
0 comments
Feb 24, 202323 min read
Calling C# code from VBA (COM interop)
Update October 2024: This post uses Visual Studio and/or RegAsm to 'statically' register your C# library before it is loaded and used by...
11 comments
Jan 18, 20233 min read
Refactor / rename in VBA
One of the commands that is provided by VBE_Extras is the ability to rename a declaration and all the references of that declaration....
0 comments
Articles: Blog2
bottom of page