The EnumChildWindows Windows API Function enumerates all child windows of a (parent) window ... and it does so recursively in that all child windows of those child windows (ie so grandchild windows) a...

This code shows the 'Font' dialog box and allows all of the values within it both to be set, before it is shown, and read after it is shown. This means that your code can allow the user to select a fo...

TaskDialogIndirect provides functionality way beyond that of a normal MsgBox (and way beyond that of a normal TaskDialog). This post demonstrates how to use TaskDialogIndirect to show a progress bar.

TaskDialogIndirect provides functionality way beyond that of a normal MsgBox (and way beyond that of a normal TaskDialog). TaskDialogIndirect can include: both a 'main instruction' heading and 'conten...

TaskDialog provides "MsgBox-like" functionality - but enhanced with options for both a 'main instruction' heading and 'content' within the body of the dialog and options for many more buttons.

This post provides helper functionality for using the TaskDialog and TaskDialogIndirect Windows API Functions. I'll follow-up this post with code for 3 Class Modules that 'wrap' TaskDialog and TaskDia...

VBE_Extras will now convert declaration(s) between Consts and an Enum. If the cursor / selection is one or multiple Consts, VBE_Extras converts those Consts to an Enum (one Enum member for each Const)...

Using GDI+ to draw lines, fill shapes and write text on a UserForm

The PeekMessage Windows API Function retrieves windows messages from a message queue. The TranslateMessage Windows API Function translates virtual-key messages into character messages.

This post demonstrates how to use the SetPixel and GetPixel Windows API Functions to set (and get) the colour of individual pixels on the surface of a UserForm.

Get a list of all fonts (or font / character set combinations) on a device using the EnumFontFamiliesEx Windows API Function.

The GetDeviceCaps Function provides information on the graphics / display capabilities (hence "Caps") of a device ... information such as the widths and heights of screens in millimetres or pixels; monitor resolution; numbers of available brushes, pens, colours and fonts; other detailed information relating to the GDI library that this Function is part of such as its ability to perform shading and its ability to draw certain types of curves.

This post covers a number of Windows API Functions relating to getting windows and getting information about windows.

This post demonstrates how to use the GetLocaleInfoEx Windows API Function to get locale-related information.

This post demonstrates how to use the FlashWindow or FlashWindowEx Windows API Functions to flash the taskbar icon and window for an application.

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

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

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

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

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