Blog posts

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

2 comments

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

0 comments

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

7 comments

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

1 comment

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

1 comment

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

0 comments

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

0 comments

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

1 comment

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

0 comments

Feb 22, 20221 min read

Does a file or folder exist?

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

0 comments

Articles: Blog2