When the Text Tools add-in opens, it creates a new menu item on the Tools menu: Text Tools Utility. Selecting this item executes the RunTextTools procedure, which checks to make sure that Excel is in the proper context (a worksheet is active) and then displays the main Text Tools Utility dialog box.
The user can specify various modifications and click the Apply button to perform them. The changes are visible in the worksheet, and the dialog box remains displayed. Each operation can be undone, or the user can perform additional text modifications. Clicking the Help button displays a help window, and clicking the Close button dismisses the dialog box. Note that this is a modeless dialog box: In other words, you can keep working in Excel while the dialog box is displayed.
Was this article helpful?