Blog posts

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.

Let VBE_Extras take away the strain of choosing different colours (as well as the eye-strain) by using the Themes functionality to allow you to switch into "Dark Mode" using the built-in Dark Theme.

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

VBE_Extras will now let you copy code direct from the VBE 'in colour' and using a specific font name and size. How does it do this? Actually, what it does is copy the code as HTML (with some CSS for styling).

Quickly expand the selection ... a word, a line, a 'block', a procedure ... and contract back to where you started

Restore your VBA code to an earlier point in time with 'restore points' functionality provided by VBE_Extras.

Interpolation means 'inserting one thing into another'. In this case, inserting one (or more) 'sub' Strings into another 'main' String.