Writing Excel Macros with VBA

Note: Supplemental materials are not guaranteed with Rental or Used book purchases.

ISBN: 9780596003593 | 0596003595
Cover: Paperback
Copyright: 6/1/2002

Buy Used

Usually Ships in 2-4 Business Days

$29.39
Buy New

In Stock Usually Ships in 24-48 Hours

$38.40
eBook

Available Instantly

Online: 1825 Days

Downloadable: Lifetime Access

$35.99

Microsoft Excel is the leading desktop spreadsheet product. To achieve the maximum efficiency, control and flexibility often requires careful custom programming using the VBA language. Writing Excel Macros with VBA, 2nd Edition offers a solid introduction to writing VBA macros and programs in Excel and shows readers how to get more power out of Excel at the programming level: focusing on programming languages, the Visual basic editor, handling code, and the Excel object model.

Preface

Introduction

(8)

Selecting Special Cells

(2)

Setting a Chart's Data Point Labels

(1)

Topics in Learning Excel Programming

(5)

Part I. The VBA Environment

Preliminaries

(7)

What Is a Programming Language?

(2)

Programming Style

(5)

The Visual Basic Editor, Part I

(12)

The Project Window

(5)

The Properties Window

(1)

The Code Window

(4)

The Immediate Window

(1)

Arranging Windows

(2)

The Visual Basic Editor, Part II

(19)

Navigating the IDE

(1)

Getting Help

(1)

Creating a Procedure

(1)

Run Time, Design Time, and Break Mode

(1)

Errors

(4)

Debugging

(6)

Macros

(5)

Part II. The VBA Programming Language

Variables, Data Types, and Constants

(22)

Comments

(1)

Line Continuation

(1)

Constants

(3)

Variables and Data Types

(17)

VBA Operators

(1)

Functions and Subroutines

(9)

Calling Functions

(1)

Calling Subroutines

(1)

Parameters and Arguments

(4)

Exiting a Procedure

(1)

Public and Private Procedures

(1)

Project References

(2)

Built-in Functions and Statements

(15)

The MsgBox Function

(2)

The InputBox Function

(1)

VBA String Functions

(3)

Miscellaneous Functions and Statements

(3)

Handling Errors in Code

(5)

Control Statements

(10)

The If Then Statement

(1)

The For Loop

(2)

The For Each Loop

(1)

The Do Loop

(1)

The Select Case Statement

(1)

A Final Note on VBA

(5)

Part III. Excel Applications and the Excel Object Model

Object Models

103

(12)

Objects, Properties, and Methods

103

(1)

Collection Objects

104

(3)

Object Model Hierarchies

107

(1)

Object Model Syntax

107

(2)

Object Variables

109

(6)

Excel Applications

115

(17)

Providing Access to an Application's Features

116

(4)

Where to Store an Application

120

(8)

An Example Add-In

128

(4)

Excel Events

132

(7)

The Enable Events Property

132

(1)

Events and the Excel Object Model

133

(1)

Accessing an Event Procedure

133

(1)

Worksheet Events

134

(1)

WorkBook Events

134

(1)

Chart Events

135

(1)

Application Events

136

(2)

QueryTable Refresh Events

138

(1)

Custom Menus and Toolbars

139

(23)

Menus and Toolbars: An Overview

139

(3)

The CommandBars Collection

142

(1)

Creating a New Menu Bar or Toolbar

143

(1)

Command-Bar Controls

144

(3)

Built-in Command-Bar-Control IDs

147

(2)

Example: Creating a Menu

149

(1)

Example: Creating a Toolbar

150

(2)

Example: Adding an Item to an Existing Menu

152

(1)

Augmenting the SRXUtils Application

153

(9)

Built-In Dialog Boxes

162

(5)

The Show Method

165

(2)

Custom Dialog Boxes

167

(16)

What Is a UserForm Object?

168

(1)

Creating a UserForm Object

168

(1)

ActiveX Controls

169

(1)

Adding UserForm Code

169

(2)

Excel's Standard Controls

171

(2)

Example: The ActivateSheet Utility

173

(5)

ActiveX Controls on Worksheets

178

(5)

The Excel Object Model

183

(8)

A Perspective on the Excel Object Model

183

(3)

Excel Enums

186

(3)

The VBA Object Browser

189

(2)

The Application Object

191

(33)

Properties and Methods of the Application Object

194

(25)

Children of the Application Object

219

(5)

The Workbook Object

224

(19)

The Workbooks Collection

224

(6)

The Workbook Object

230

(8)

Children of the Workbook Object

238

(3)

Example: Sorting Sheets in a Workbook

241

(2)

The Worksheet Object

243

(20)

Properties and Methods of the Worksheet Object

243

(8)

Children of the Worksheet Object

251

(4)

Protection in Excel XP

255

(2)

Example: Printing Sheets

257

(6)

The Range Object

263

(69)

The Range Object as a Collection

265

(1)

Defining a Range Object

266

(6)

Additional Members of the Range Object

272

(31)

Children of the Range Object

303

(14)

Example: Getting the Used Range

317

(2)

Example: Selecting Special Cells

319

(13)

Pivot Tables

332

(65)

Pivot Tables

332

(3)

The PivotTable Wizard

335

(4)

The PivotTableWizard Method

339

(2)

The PivotTable Object

341

(6)

Properties and Methods of the PivotTable Object

347

(15)

Children of the PivotTable Object

362

(1)

The PivotField Object

362

(17)

The PivotCache Object

379

(1)

The PivotItem Object

380

(5)

PivotCell and PivotItemList Objects

385

(4)

Calculated Items and Calculated Fields

389

(2)

Example: Printing Pivot Tables

391

(6)

The Chart Object

397

(66)

Chart Objects and ChartObject Objects

397

(2)

Creating a Chart

399

(6)

Chart Types

405

(4)

Children of the Chart Object

409

(1)

The Axes Collection

410

(3)

The Axis Object

413

(11)

The ChartArea Object

424

(1)

The ChartGroup Object

425

(4)

The ChartTitle Object

429

(1)

The DataTable Object

430

(1)

The Floor Object

430

(1)

The Legend Object

431

(2)

The PageSetup Object

433

(1)

The PlotArea Object

433

(1)

The Series Object

434

(7)

Properties and Methods of the Chart Object

441

(5)

Example: Scrolling Through Chart Types

446

(3)

Example: Printing Embedded Charts

449

(5)

Example: Setting Data Series Labels

454

(9)

Smart Tags

463

(72)

What Are Smart Tags?

463

(1)

SmartTagRecognizer Object

464

(1)

SmartTag Object

465

(1)

SmartTagAction Object

466

(1)

SmartTagOptions Object

466

(5)

Part IV. Appendixes

A. The Shape Object

471

(13)

B. Getting the Installed Printers

484

(4)

C. Command Bar Controls

488

(11)

D. Face IDs

499

(6)

E. Programming Excelfrom Another Application

505

(5)

F. High-Level and Low-Level Languages

510

(10)

G. New Objects in Excel XP

520

(15)

Index

535

Please wait while the item is added to your bag...

FREE SHIPPING

Amazon no longer offers textbook rentals. We do!

Writing Excel Macros with VBA

Summary

Table of Contents

Supplemental Materials