Blog posts

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

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.

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

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

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

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

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

Aug 25, 20223 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 10, 20224 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,...

Jul 29, 20221 min read

Automatically adding Properties

Get fed up with manually typing out Properties? VBE_Extras can now automatically add Properties for module-level variables and Type...

Articles: Blog2