Blog posts

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

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

The close (or 'X') button appears at the right in the title bar of every UserForm. You can control the behaviour when it is clicked, or...

Adding an icon to a UserForm's title bar can help to give a professional look to your UserForm. The source icon must be a .ico file. If...

The examples here all work with Excel, Word and PowerPoint, they do not work with Outlook. Set the Ribbon visibility These methods allow...