Blog posts

I wanted to have a simple piece of code that I could drop into any host application in which I am developing VBA code that would get me the application window handle ...

This post concerns working with the Registry outside of the "HKEY_CURRENT_USER\Software\VB and VBA Program Settings" key.

Working with files and folders from VBA code can be a hassle - here's my standard procedures to make working with files and folders simpler

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?

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. In the UserForm's code in the declarations area, add the Windows API calls and associated constants ​​ 2. And in the UserForm's code area below the declarations, add the SetTransparency procedure ​​ 3. And from the UserForm_Initialize event, call the SetTransparency procedure ​ 4. That's it. The only thing left to do is to display the User

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 showing a modeless 'progress bar' dialog. 1. In the UserForm's code in the declarations area, add the Windows API calls and associated constants ​ 2. And in the UserForm's code in the procedures area, add this SetNoTitleBar procedure ​ 3. And from the UserForm_Initialize event, call the SetNoTitleBar procedure 4. Display the UserForm (in this exam

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 you can hide it. Why would you want to do that? Normally, you wouldn't. And shouldn't. Normally the user should be able to close a UserForm whenever they want and your code should handle that outcome. However, just occasionally, it might be essential to ensure that a user has acknowledged some text or made a selection ... an example might be

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 image file you want to use is not a .ico file then you can use one of a number of online image converters to convert it from .jpg or .png etc to .ico ... search along the lines of "convert to icon file". Once you have your .ico file: ​ 1. Add a UserForm to your VBA Project 2. Add an Image control to the UserForm and change its Name proper

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

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