Blog posts

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.

May 23, 20236 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

Apr 20, 20231 min read

Using mouse clicks to navigate VBA code in the VBE

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.

Apr 12, 20239 min read

Adding a Button (and a ComboBox) to the Ribbon

Dynamically adding controls to a UserForm and reacting to their events

Programmatically adding controls to a UserForm and reacting to their events

Mar 31, 20235 min read

Dynamically adding controls to a UserForm and reacting to their events

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

Mar 10, 20231 min read

VBE_Extras now available in Microsoft Access

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

Mar 8, 20233 min read

Changing UserForm Button colour on mouse hover

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

Feb 24, 202323 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. It's much more than find/replace ... read this post to find out why ...

Jan 18, 20233 min read

VBA and FaceIds

A FaceId, in VBA, is a small picture/icon added to a CommandBarButton which is an item in a menu. The main menus in all Office...

Aug 25, 20223 min read

Let the user choose a single file

A common requirement for VBA macros is to let the user choose a file, often the file will have some data that the macro is to work with,...

Aug 10, 20224 min read

Articles: Blog2