Index_I

I

i variable, 115-16, 118

icons, transforming windows into, 221-22

id field, 675

Id values, 473

If condition Then, 113

If field, 593

IF formulas, 499-500

If statement, 31

IfThenElse, 112-13

Image and Text setting, 461

Image object, 831

images

editing in menu items and tools, 461-62

properties of, 431-32

immediate window, 81-82

as debugging tool, 374

experimentation in, 368

Imp operators, 114, 178

Implements keyword, 51, 164

importing, 626-44

from databases (MS Query), 627-39

tables and relations, 634

listing of all orders, 631-33

loading and saving queries, 639

options for inserting external data, 638-39

overview, 627

product list example, 628-30

queries executed on request, 637

sales by employee example, 634-35

selecting data source, 627-28

sort and filter criteria, 636

SQL code, 636-37

updating data, 630-31

in Excel 2000, 54

from HTML, 739-40

and QueryTable object, 639-43

text files, 286-94

and OpenText method, 289-92

overview, 286

and QueryTable object, 292-94

syntax summary, 304

Text Import wizard, 287-89

In keyword, 117

incoming folders, 670, 676, 678, 684, 684-85

incompatibilities, 59-64

IncreaseFontSize procedure, 206

Increment field, 675

indenting code, 78

IndentLevel property, 58, 195

index range, 94

indexes, 572, 573

Initial Catalog parameter, 652

Initialize event, 436

initialize procedures, 164

InitializeApplicationEvents, 152

InitializeListboxes procedure, 612, 614

InitRandomnumbers procedure, 548

INNER JOIN query, 664, 665

Input command, 240, 278, 280, 305

InputBox form, 616

InputBox function, 240, 392-93

inputting data

with Database form, 579-80

macros for simplifying, 15-17

Insert Into command, 666, 668

Insert method, 194

InsertClass Module command, 76, 161

InsertDiagram command, 49, 565

InsertField, 593

InsertFunction dialog, 56, 98, 110

InsertFunction form, 308

InsertModule command, 30, 76

Insert Name Apply form, 192

InsertNameDefine command, 187, 202

InsertProcedure command, 77

InsertUserForm command, 34, 76

inserting

charts , 541

comments, 18

data, 214, 229-30

external data, options for, 638-39

InsertLines method, 155

insertRecord, 106

installing

ClipBoard object, 772

EuroConvert function, 341

new database, 576

Instancing property, 164-65

InStr function, 236, 238, 615

InstrRev function, 237

instructions, skipping or repeating, 377

Int function, 233, 244

Int variables , 282

Integer variables, 88, 90, 95, 100

Integrated Security parameter, 652

IntelliSense functions, 77

interactive mode, 740-42

Interactive property, 360

interest in savings account example, 24-30

cell protection, 28

model for table of interest, 24-27

overview, 24

printing options, 28

table layout, 28

templates, 29-30

validation control, 28-29

Interior object, 831

internal management, 720-27

InternalFunction function, 734-35

Internet features, of Excel 2000, 53

interrupting macros, 81

interruption of program. See program interruption

Intersect method, 191, 204

intro objects, 647, 648

intro parameter, 647

Intro worksheet, 547, 710

Intro5.xlt file, 30

invisible worksheets, 507-8

invoice form

balance sheet example, 614-15

"Speedy" invoice form example

controls, 511

design elements, 512-13

essential fields, 509-10

predefined formulas for discount calculation, 510-11

program code, 513-14

shortcomings, 517-18

InvoiceCorrect Old Invoice of This Month command, 603

InvoiceNew command, 603

InvoicePrint and Save command, 603

Is operator, 60, 115, 137, 178

IsArray function, 246

IsDate function, 89, 243, 246

IsDate(variable), 96

IsEmpty function, 89, 243, 246

IsEmpty(variable), 96

IsError function, 89, 246

IsError(variable), 96

IsMissing function, 103, 246

IsNull function, 89, 235, 243, 246

IsNull(variable), 96

IsNumeric function, 89, 243, 246

IsNumeric(variable), 96

IsObject function, 89, 246

IsObject(variable), 96

IsReady property, 302

IsRootFolder property, 273, 302

IsXxx functions, 114, 243

Italics property, 61