Blog posts

Aug 31, 20233 min read

A better Application.OnTime ... run your VBA code to the nearest millisecond (ish)

Application.OnTime is great if you want to call your procedure to the nearest second. What do you do if you want finer control than that?

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

Pause processing

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

Feb 22, 20221 min read

Get the local date and time including milliseconds

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

Articles: Blog2