Visual Basic for Applications/Styling User Forms

Summary

 * FormatForm is used to format a single specified userform with pre-selected colorings and fonts.  This replaces a previous procedure to format all open userforms. Assumes that a userform called UserForm1 exists.
 * The procedure AutoFormat performs auto-sizing and layout for simple array data, so that the display and label bar is tabular in appearance, regardless of the length of the various data.  This latter procedure also has facilities to transpose the input in case it is needed.

Last Modified 10 Jun 2017
Corrected name of TransposeArr2D in Autoformat. (12 Jul 2019) Replaced multi-form procedure with single-form procedure FormatForm.(18 Jan 19) Changed code to more general TypeName in FormatAllLoadedUserForms(28 June 18) Added transpose function, previously omitted (10 Jun 2017) Removed font procedures to their new page Reduced number of AutoFormat controls.(17 Nov 2016) Added GetTextPoints. (17 Nov 2016)