Blog posts

Programmatically adding controls to a UserForm and reacting to their events

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

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

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

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

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

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

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

What's a factory? For the purposes of this article: it is code within in a Class Module that creates an instance of that Class, assigns...

What is an Attribute? A name/value pair that specifies some characteristic of a Module or Module-member. All Attributes are hidden when...