Key Points


  • Use Help to find annotated lists of all the members for an object. Even if you’re not on-line, there is offline help available on your computer.

  • Add new items to the ColorStops collection of a cells gradiant format to get multiple colors that are not available in the user interface.

  • Take advantage of the Adjustments for shapes to multiply the number of available shapes available.

  • When a shape contains grouped objects, you can use the GroupShapes collection to access the subordinate shapes without ungrouping and regrouping the shape.

  • When the macro recorder doesn’t show you the methods and properties for an object, look at the user interface for clues.



Microsoft Office Excel 2007 Visual Basic for Applications Step by Step
Microsoft Excel 2002 Visual Basic for Applications Step by Step (Step by Step (Microsoft))
ISBN: 0735613591
EAN: 2147483647
Year: 2004
Pages: 99
Authors: Reed Jacobsen

Similar book on Amazon
Excel 2003 Power Programming with VBA (Book & CD-ROM)
Excel 2003 Power Programming with VBA (Book & CD-ROM)
Microsoftu00ae Office Excelu00ae 2007 Visual Basicu00ae for Applications Step by Step (BPG-step by Step)
Microsoftu00ae Office Excelu00ae 2007 Visual Basicu00ae for Applications Step by Step (BPG-step by Step)
Excel 2003 Formulas
Excel 2003 Formulas
Writing Excel Macros with VBA, 2nd Edition
Writing Excel Macros with VBA, 2nd Edition

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