After completing this chapter, you will be able to:
Get a 3-foot-by-4-foot piece of plywood and some cans of blue, yellow, and orange paint. Drip, dribble, splash, and spread the paint on the plywood. You now have-a mess. But put a $500 frame around the painted plywood, and you now have-a work of art! Even serious art doesn't look earnest without a good frame, and the best diamond brooch doesn't seem to be a precious gift if given in a paper bag.
Similarly, you can write macros that are practical, convenient, and useful, but until you put a frame around them-until you tighten up the edges, make them easy to use, and package them-you don't have a truly valuable application. Creating a custom form is an excellent way to make functionality easy to use and valuable. In this chapter, you'll learn how to create a custom form, create the functionality for the form, and link the two together into an integrated tool.
On the CD This chapter uses the practice file Budget.xls that you installed from the book's CD-ROM. For details about installing the practice files, see 'Using the Book's CD-ROM' at the beginning of the book.