Blog posts

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

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

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

Code often needs to pause and wait for something else to happen. There are a number of options to do this. In Excel, you can use...

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

What is VBA VBA stands for Visual Basic for Applications. VBA is Microsoft’s programming language for a number of the Office suite of...

This code uses the GetLocalTime Windows API to get a more accurate time than VBA will supply, accurate to around 15 milliseconds. You can...