Chapter 48: Creating Custom Excel Add-Ins
48
To test it, save the XLSM version of the workbook, close it, and then reopen it. With the
workbook open, activate a different workbook, select some cells that contain text, and then
press Alt+F8 to display the Macros dialog box. Execute the ShowChangeCaseUserForm
macro and try all of the options.
FIGURE 48.3
The custom dialog box
Adding descriptive information
Adding descriptive information is recommended but not necessary. Choose File ➪ Info and
click Show All Properties at the bottom of the right panel (see Figure 48.4). Enter a title for
the add-in in the Title field. This text appears in the Add-Ins dialog box. In the Comments
field, enter a description. This information appears at the bottom of the Add-Ins dialog box
when the add-in is selected.
FIGURE 48.4
Adding descriptive information about your add-in