Book 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
For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.
Table of contents
- Features and Conventions of This Book
- Using the Book’s CD
- Getting Help
- 1. Make a Macro Do Simple Tasks
- 2. Make a Macro Do Complex Tasks
- 3. Explore Workbooks and Worksheets
- 4. Explore Range Objects
-
5. Explore Data Objects
- Chapter at a Glance
- Working with Excel Tables
-
Working with PivotTable Reports
- Create a PivotTable Report from an Internal Source
- Create a PivotTable Report from an External Source
- Record a Macro to Set the PivotTable Structure
- Set the PivotTable Structure
- Record a Macro to Customize a PivotTable Layout
- Customize a PivotTable Layout
- Record a Macro to Customize a PivotTable Style
- Customize a PivotTable Style
- Key Points
- 6. Explore Graphical Objects
- 7. Control Visual Basic
- 8. Extend Excel and Visual Basic
- 9. launch Macros with Events
- 10. Use Dialog Box Controls on a Worksheet
- 11. Create a Custom Form
- A. A Complete Enterprise Information System
- Index
- About the Author
- Copyright
Product information
- Title: Microsoft® Offic Excel® 2007 Visual Basic® for Applications Step by Step
- Author(s):
- Release date: May 2007
- Publisher(s): Microsoft Press
- ISBN: 9780735624023
You might also like
book
Microsoft Office Access 2007 - Das Handbuch
Dieses Handbuch zeigt umfassend und leicht verständlich, wie Sie mit Access 2007 Datenbanken aufbauen, nutzen und …
book
Microsoft® Visual C#® 2012 Step by Step
Teach yourself how to build applications with Microsoft Visual C# 2012 and Visual Studio 2012—one step …
book
Expert C# 2008 Business Objects
Do you want to create .NET applications that provide high performance and scalability? Do you want …
book
Power Phone Scripts
Start closing sales like top producers! Have you ever found yourself at a loss for what …