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