VBA and Macros for Microsoft Excel

Index

Symbols

| (pipe character), 342

3D charts, 204-205

A1 references, 123

A1Style() function, 127

above-average records, 230

absolute references, 25-27, 128-129

accelerator keys, 453

Access databases

ADO (ActiveX Data Objects), 408-410

case study, 409-410

connecting to, 410

DAO (Data Access Objects), 408

fields

checking existence of, 418-419

inserting, 419-420

MDB (Multidimensional Database) files, 407

reading data from, 410

records

adding, 410

deleting, 410, 416

inserting, 410-412

retrieving, 412-413

summarizing, 416-417

updating, 414-415

tables

checking existence of, 417-418

inserting, 419

AccountingReport() function, 267-268

Activate() event, 149, 155, 159

active controls, coloring, 454-456

ActiveX controls, attaching macros to, 500

Get VBA and Macros for Microsoft Excel now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.