Microsoft Excel 2007 Visual Basic for Applications Step by Step

Description

Quickly teach yourself how to automate tasks and create custom spreadsheet solutions with Excel 2007 Visual Basic for Applications (VBA). With Step By Step, you set the pace - building and practicing the skills you need, just when you need them!

* Create macros to automate repetitive tasks
* Automatically format charts, shapes, and text
* Manipulate tables and other objects - even build PivotTable reports
* Write your own functions and procedures
* Use loops and conditions to add decision logic to macros
* Build custom command buttons, dialog boxes, and user forms

Your all-in-one learning experience includes:

* Files for building skills and practicing the book’s lessons
* Fully searchable eBook
* Windows Vista Product Guide eReference - plus other resources on CD

CONTENTS:

Features and Conventions of This BookUsing the Book's CDGetting HelpChapter 1: Make a Macro Do Simple TasksChapter 2: Make a Macro Do Complex TasksChapter 3: Explore Workbooks and WorksheetsChapter 4: Explore Range ObjectsChapter 5: Explore Data ObjectsChapter 6: Explore Graphical ObjectsChapter 7: Control Visual BasicChapter 8: Extend Excel and Visual BasicChapter 9: launch Macros with EventsChapter 10: Use Dialog Box Controls on a WorksheetChapter 11: Create a Custom FormA Complete Enterprise Information System