Blog posts

This post demonstrates how to use the GetKeyState Windows API Function to test the state of specific keys ... in this case, the Shift, Ctrl, Alt, Caps Lock and Num Lock keys.

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.