top of page
Blog posts
Search
Showing the 'Font' dialog box using the ChooseFont Windows API Function
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 font, including: the font name; the font style (eg italic, bold); the font size; whether the font is 'strikeout'; whether the font is 'underlined'; the font colour; the specific script (ie the charset).
Nov 17, 20253 min read
Â
Â


TaskDialogIndirect ... as a progress bar
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.
Nov 4, 20256 min read
Â
Â


TaskDialogIndirect ... supercharged MsgBox
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 'content' within the body of the dialog; an icon in the body of the dialog (either a built-in icon or a custom icon); radio buttons; in addition to 'standard' buttons, either buttons with custom text or command links; a verification checkbox; a footer; an 'expanded information' area; hy
Oct 30, 20259 min read
Â
Â


TaskDialog ... MsgBox plus
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.
Oct 22, 20253 min read
Â
Â


TaskDialog and TaskDialogIndirect helper functionality
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 TaskDialogIndirect over a series of subsequent posts.
Oct 20, 20254 min read
Â
Â


Consts to Enum / Enum to Consts
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). If the cursor is within an Enum (or the entire selection is an Enum), VBE_Extras converts that Enum to Consts (one Const for each Enum member).
Oct 15, 20251 min read
Â
Â


Using GDI+ to draw lines, fill shapes and write text on a UserForm
Using GDI+ to draw lines, fill shapes and write text on a UserForm
Oct 14, 20255 min read
Â
Â


Get key presses while VBA code is running using PeekMessage and TranslateMessage
The PeekMessage Windows API Function retrieves windows messages from a message queue. The TranslateMessage Windows API Function translates virtual-key messages into character messages.
Oct 9, 20253 min read
Â
Â


Drawing individual pixels with the Windows API
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.
Sep 23, 20252 min read
Â
Â


Get a list of all Fonts installed on a device using the EnumFontFamiliesEx Windows API Function
Get a list of all fonts (or font / character set combinations) on a device using the EnumFontFamiliesEx Windows API Function.
Sep 17, 20253 min read
Â
Â


Articles: Blog2
bottom of page