OverviewAfter completing this chapter, you will be able to:
On a warm summer day, nothing beats lying on your back in a grassy field, watching clouds float across the sky. Trees, mountains, and buildings just sit there, attached firmly to the ground. But clouds move. Clouds change shape. They change color. Clouds can come in layers, too, with closer clouds drifting in front of the clouds in back. On a worksheet, ranges with their formulas and formats are attached firmly to the worksheet, just as buildings are attached firmly to the ground. Cell A1 will always be in the upper left corner of the worksheet. Drawing objects, however, are like clouds. They float freely above the worksheet. They can disappear and reappear. They can change color and shape. Drawing objects-including not only shapes such as rectangles, ovals, and lines, but also charts, list box controls, and spinner controls-add interest, information, and functionality to a worksheet. In this chapter, you'll learn how to use Microsoft Visual Basic for Applications macros to control drawing objects. On the CD This chapter uses the practice file Graphics.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 this book. |