Automatically adding factories
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...
top of page
Blog posts
Search
Jul 20, 202214 min read
VBA Attributes
What is an Attribute? A name/value pair that specifies some characteristic of a Module or Module-member. All Attributes are hidden when...
May 23, 20222 min read
VBE_Extras is here!
VBE_Extras is an AddIn for the Visual Basic Editor (VBE) within Excel, Word, Outlook and PowerPoint. It is designed to make coding with...
Mar 4, 20229 min read
Installing and updating Add-ins
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...
Feb 26, 20221 min read
Make a UserForm transparent
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!...
Feb 25, 20221 min read
Hide a UserForm's title bar
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...
Feb 25, 20222 min read
Working with a UserForm's close button (the 'X' button)
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...
Feb 24, 20222 min read
Add an icon to a UserForm's title bar
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...
Feb 22, 20222 min read
Get or set the Ribbon visibility
The examples here all work with Excel, Word and PowerPoint, they do not work with Outlook. Set the Ribbon visibility These methods allow...
Feb 22, 20221 min read
Join two parts of a file or folder path
NOTE: this post and the code it contains is still valid, however, it has been superseded by the 'Working with files and folders in VBA'...
Articles: Blog2
bottom of page