After completing this chapter, you will be able to:

  • Manipulate drawing objects on a worksheet.

  • Manipulate chart objects.

  • Use the macro recorder as a reference tool.

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.

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