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

VBE_Extras will now help you to create and apply text, background and indicator colours, fonts and 'margin indicator bar' (MIB)...

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

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