After completing this chapter, you will be able to:

  • Create a custom form.

  • Initialize a form.

  • Check for invalid input values in a text box.

  • Run macros from a form.

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.

Microsoft Excel 2002 Visual Basic for Applications Step by Step
FrameMaker 6: Beyond the Basics
ISBN: 735613591
EAN: 2147483647
Year: 2005
Pages: 122
Authors: Lisa Jahred

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net