Blog posts

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 editing VBA code directly in the VBE. What can I do with Attributes? All sorts of things. They define the names of Modules. They define the descriptions, seen in the Object Browser, of Modules and Module members. They define whether a class Module has a default instance, is iterable, has a default member and whether objects created from a Cla

VBE_Extras is an AddIn for the Visual Basic Editor (VBE) within Excel, Word, Outlook and PowerPoint. It is designed to make coding with...

Installing and updating an Add-in for an Office application is not difficult. Honest, it's not. But the right steps have to be performed...

The following code will make the entire UserForm transparent. I'm sure there is a practical use for this, I'm just now sure what it is! 1. In the UserForm's code in the declarations area, add the Windows API calls and associated constants ​​ 2. And in the UserForm's code area below the declarations, add the SetTransparency procedure ​​ 3. And from the UserForm_Initialize event, call the SetTransparency procedure ​ 4. That's it. The only thing left to do is to display the User

The following code will hide the whole title bar of the UserForm window. Why would you want to do this? The only time I do is when showing a modeless 'progress bar' dialog. 1. In the UserForm's code in the declarations area, add the Windows API calls and associated constants ​ 2. And in the UserForm's code in the procedures area, add this SetNoTitleBar procedure ​ 3. And from the UserForm_Initialize event, call the SetNoTitleBar procedure 4. Display the UserForm (in this exam