Blog posts

This post demonstrates how to use the GetDefaultPrinter, SetDefaultPrinter and EnumPrinters Windows API Functions to, respectively, get the name of the active printer, set the active printer and list all available printers.

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.