Blog posts

Setting file / folder attributes using the SetFileAttributes Windows API Function

Getting file / folder attributes using the GetFileAttributes Windows API Function

Often, especially when creating text to show to a user in a dialog, I have a Collection or Array of Strings that I want to use to inform the user of some information. Code to compile those Strings into "clean" user-friendly text can be a pain to write ... for example, making sure the penultimate and last items are delimited by "and" instead of a comma especially when you don't know how many Strings will be included from the off.

The standard VBA.InputBox (and Application.InputBox, available if working in Excel) only allow you to enter a single line of text. What to do if you want to allow a user to enter multiple lines of text? Use a UserForm with a multiline TextBox ...

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) are also enumerated, as are great-grandchild windows, great-great-grandchild windows and so on. This makes EnumChildWindows very handy if you want to get a list of all such windows, or if you want to get all such window(s) with a specific caption and/or class name.

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

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

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 TaskDialogIndirect over a series of subsequent posts.