The VBA Help blog

VBE_Extras extends the built-in "F1" functionality to open the Microsoft documentation web page for Windows API Functions (i.e. that you have declared using the 'Declare' keyword), Types, Enums and Consts.

VBE_Extras will help you to identify and add (to your VBA code) Windows API declarations.

This post provides code that you can use to customise the text in message box buttons. You can show the message box with 1, 2 or 3 buttons and get the text of the clicked button back.

Showing a MsgBox dialog to a user is great to inform them of stuff or get input. But it can be a problem if the user isn't paying attention to your application and doesn't notice the dialog. But a dialog with a timeout ... using the Windows API function "MessageBoxTimeout" ... won't wait indefinitely ... it'll wait as long as you want it to wait.

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