The Text Tools workbook

The Text Tools utility is an XLAM add-in file. During development, I worked with the file as a macro-enabled XLSM workbook. When I was satisfied that all was working properly, I saved the workbook as an add-in.

The Text Tools workbook consists of the following components:

■ One worksheet: Every workbook must have at least one worksheet. I take advantage of this fact and use this worksheet to handle the undo procedure (see "Implementing Undo ," later in this chapter).

■ One VBA module: This module contains public variable and constant declarations, the code to display the UserForm, and the code to handle the undo procedure.

■ One UserForm: This contains the dialog box. The code that does the actual text manipulation work is stored in the code module for the UserForm.

Installing an Add-In

To install an add-in, including the ® text tools. xlam add-in, follow these steps:

1. Select Office Excel Options.

2. In the Excel Options dialog box, click the Add-Ins tab.

3. In the drop-down list labeled Manage, select Excel Add-Ins and then click Go to display the Add-Ins dialog box.

4. If the add-in that you want to install is listed in the Add-Ins Available list, place a check mark next to the item. If the add-in is not listed, click Browse to locate the XLAM or XLA add-in file.

5. Click OK, and the add-in will be installed. It will remain installed until you deselect it from the list.


The file also contains some manual modifications that I made in order to get the command to display on the Ribbon. See "Adding the RibbonX code ," later in this chapter. Unfortunately, it's not possible to modify Excel's Ribbon using only VBA.

0 0


  • markku
    Which of the following is not one of the four steps in workbook development?
    7 years ago

Post a comment