Ordinal Numbers Suffixes

Starting with Excel 2007, it is possible to specify the number format as part of conditional formatting. This note shows how to leverage that capability to add the appropriate suffix to an ordinal number (e.g., 1st, 2nd, 3rd, 4th, etc.) For a version in a page by itself (i.e., not in a scrollable iframe as …

Continue reading ‘Ordinal Numbers Suffixes’ »

Extend an object’s attributes to coordinate multiple userform controls

This was motivated by a question in the mrexcel.com forum. The person asking for help had multiple comboboxes in a userform, each of which contained the same items, A through L for the purpose of this exercise. These items were sorted alphabetically. He wanted that when the user selected an item in any of the …

Continue reading ‘Extend an object’s attributes to coordinate multiple userform controls’ »