Writing Excel Macros with VBA

Despite its powerful feature set, you've probably found that there's a lot that you can't do -- or can't do easily -- through Microsoft Excel's user interface. For instance, have you ever wanted to sort the worksheets in a workbook without dragging and dropping each one individually? Have you ever wanted to select a worksheet whose tab was not shown at the bottom of the workbook's window without scrolling through the tabs of all available worksheets? In fact, you can address these and innumerable other shortcomings and extend your control over Excel by using Visual Basic for Applications (VBA) to control Excel programmatically. Writing Excel Macros with VBA is the introduction to Excel VBA that allows you to do just that.
Newly updated for Excel 2002, Writing Excel Macros with VBA provides Excel users, as well as programmers who are unfamiliar with the Excel object model, with a solid introduction to writing VBA macros and programs for Excel.
Writing Excel Macros with VBA is written in a terse, no-nonsense manner that is characteristic of Steven Roman's straightforward, practical approach. Instead of a slow-paced tutorial with a lot of hand-holding, Roman offers the essential information about Excel VBA that you must master to write macros effectively. This information is reinforced by interesting and useful examples that solve common problems you're sure to have encountered.
Writing Excel Macros with VBA is the book you need to delve into the basics of Excel VBA programming, enabling you to increase your power and productivity when using Microsoft Excel.

• 1 Introduction
• 2 Preliminaries
• 3 The Visual Basic Editor, Part I
• 4 The Visual Basic Editor, Part II
• 5 Variables, Data Types, and Constants
• 6 Functions and Subroutines
• 7 Built-in Functions and Statements
• 8 Control Statements
• 9 Object Models
• 10 Excel Applications
• 11 Excel Events
• 12 Custom Menus and Toolbars
• 13 Built-In Dialog Boxes
• 14 Custom Dialog Boxes
• 15 The Excel Object Model
• 16 The Application Object
• 17 The Workbook Object
• 18 The Worksheet Object
• 19 The Range Object
• 20 Pivot Tables
• 21 The Chart Object
• 22 Smart Tags
• App. A The Shape Object
• App. B Getting the Installed Printers
• App. C Command Bar Controls
• App. D Face IDs
• App. E Programming Excelfrom Another Application
• App. F High-Level and Low-Level Languages
• App. G New Objects in Excel XP
• Index