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 declaration, the code to display the UserForm, and the code to handle the undo procedure. The code that does the actual work is stored in the code modules for the UserForm.
♦ One UserForm: This contains the dialog box.
♦ ThisWorkbook code module: This contains the code to create (and remove) the menu item on the Tools menu.
Was this article helpful?