Ani

A1 references, 117 A1Style() function, 121 above-average records, 224 absolute references, 25-27, 122-123

accelerator keys, 447

Access databases

ADO (ActiveX Data Objects), 402-404 case study, 403-404 connecting to, 404 DAO (Data Access

Objects), 402 fields checking existence of,

412-413 inserting, 413-414 MDB (Multidimensional

Database) files, 401 reading data from, 404 records adding, 404 deleting, 404, 410 inserting, 404-406 retrieving, 406-407 summarizing, 410-411 updating, 408-409

tables checking existence of,

411-412 inserting, 413

AccountingReport() function, 261-262

Activate() event, 143, 149, 153

active controls, coloring, 448-450

ActiveX controls, attaching macros to, 494

ActiveX Data Objects. See ADO

Add Watch command (Debug menu), 48

Add Watch dialog box, 49

add-ins alternatives to, 503 case study, 503-504 characteristics of, 497-498 closing, 502

converting workbooks to,

498-500 installing, 500-501 removing, 502 security, 502 .xla extension, 497

Add-Ins command (Tools menu), 500

Add-Ins dialog box, 500-502 addAConnection() function, 512-515

AddErrorBars() function, 194

AddFields() function, 259

adding cells based on interior color,

83-84 numbers, 76-77 subtotals, 254 AddInInstaUO event, 147 AddInUninstallO event, 147 Addition() function, 77 addMSlash() function, 514 AddNew() function, 405

addresses email addresses, 82-83 hyperlink addresses, 100 AddTransfer() function, 405-406

AddTrendLine() function, 194

addWiringWSTag() function, 510

ADO (ActiveX Data Objects), 402-404

ADOAddField() function,

413-414 ADOCreateReplenishO function, 413

ADOWipeOutAttribute()

function, 410 Advanced Filter, 207-208

case study, 230-233 criteria ranges, 215 case study, 218 logical AND operations,

217-218 logical OR operations,

217-218 UniqueProductsOneCus tomer() function, 216 Filter In Place option,

225-226 formula-based conditions above-average records, returning, 224 in Excel user interface, 220

setting up, 219 VBA code, 220-224 no matching records, handling, 224 unique list of values, extracting Advanced Filter dialog box, 208 AdvancedFilter() function, 209 CancelButton_Click()

function, 212 cbSubAll_Click()

function, 212 cbSubClear_Click()

function, 212 GetUniqueCustomers() function, 210

multiple field values,

214-215 OKButton_Click() function, 212 RevenueByCustomers()

function, 211 ShowCustForm() function, 213 single column list ranges, 208-209 UniqueCustomer-

Redux() function, 210 UserForm_Initialize() function, 213 xlFilterCopy, 226-227

copying all columns, 227 copying subset of columns, 228-229

Advanced Filter dialog box, 208

AdvancedFilter() function, 209

ahtAddFilterItemO function, 465

ahtCommonFileOpenSave() function, 463-465

alerts, 473-474

Alignments command (UserForm toolbar), 433

AllColumnsOneCustomer() function, 227

Amazon.com case study

Amazon Development Kit,

354-355 XML query results, 354 multiple pages of results,

356-357 sample query, 355-356

AND operator, 217-218 Anderson, Ken, 347

apiGetOpenFileName API

function, 462 apiGetSaveFileName API function, 462

AppEvent_BeforeDouble-

Click() event, 158 AppEvent_BeforeSave() event, 160

AppEvent_NewWorkbook()

event, 157 AppEvent_SheetActivate() event, 157

AppEvent_SheetBeforeRight

Click() event, 158 AppEvent_SheetCalculate() event, 158

AppEvent_SheetDeactivate()

event, 158 AppEvent_SheetFollowHype rlink() event, 158

AppEvent_WindowActivate()

event, 158 AppEvent_WindowDeactivat e() event, 159

AppEvent_WindowResize()

event, 159 AppEvent_Workbook-Activate() event, 159

AppEvent_WorkbookAddinI

nstall() event, 159 AppEvent_WorkbookAddin Uninstall() event, 159

AppEvent_WorkbookBefore Close() event, 159

AppEvent_WorkbookBefore Print() event, 160

AppEvent_WorkbookNewSh eet() event, 160 AppEvent_WorkbookOpen() event, 160

application-level events, 156-157

AppEvent_BeforeDoubleCl ick(), 158 AppEvent_BeforeSave(), 160 AppEvent_

NewWorkbook(), 157 AppEvent_SheetActivate(),

0 0

Post a comment