Microsoft Press, 2007. – 384 p.
Experience learning made easy, and quickly teach yourself Microsoft Office Excel 2007 Visual Basic for Applications (VBA) – one step at a time! Work at your own pace through the easy numbered steps and practice files on CD, and master the fundamentals for using VBA to create custom software solutions and automating tasks in Excel 2007 – no developer experience required! You'll learn how to automate spreadsheets, write your own functions and procedures, and customize menus and toolbars. You'll discover Excel Objects, including workbooks, range objects, graphics, and PivotTables. Plus, you'll learn how to chart data from databases and other information sources. With Step by Step, you can take just the lessons you need or work from cover to cover. Either way, you drive the instruction – building and practicing the skills you need, just when you need them! Includes a companion CD with hands-on practice files.
Key Book Benefits:
Includes coverage of all the fundamentals, including how to automate spreadsheets, customizing menus, and writing your own functions and procedures
Features easy-to-follow lessons and hands-on skill-building exercises
Includes a companion CD with practice files and other resources
Microsoft Office Excel 2007 Visual Basic for Applications Step by Step
Features and Conventions of This Book
Using the Book’s CD
Getting Help
Make a Macro Do Simple Tasks
Make a Macro Do Complex Tasks
Explore Workbooks and Worksheets
Explore Range Objects
Explore Data Objects
Explore Graphical Objects
Control Visual Basic
Extend Excel and Visual Basic
Launch Macros with Events
Use Dialog Box Controls on a Worksheet
Create a Custom Form
Complete Enterprise Information System