icons, transforming windows into, 221-22
Image and Text setting, 461
images
editing in menu items and tools, 461-62
properties of, 431-32
immediate window, 81-82
as debugging tool, 374
experimentation in, 368
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
incoming folders, 670, 676, 678, 684, 684-85
IncreaseFontSize procedure, 206
IndentLevel property, 58, 195
Initial Catalog parameter, 652
initialize procedures, 164
InitializeApplicationEvents, 152
InitializeListboxes procedure, 612, 614
InitRandomnumbers procedure, 548
INNER JOIN query, 664, 665
Input command, 240, 278, 280, 305
InputBox function, 240, 392-93
inputting data
with Database form, 579-80
macros for simplifying, 15-17
Insert Into command, 666, 668
InsertClass Module command, 76, 161
InsertDiagram command, 49, 565
InsertFunction dialog, 56, 98, 110
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
installing
ClipBoard object, 772
EuroConvert function, 341
new database, 576
Instancing property, 164-65
InStr function, 236, 238, 615
instructions, skipping or repeating, 377
Integer variables, 88, 90, 95, 100
Integrated Security parameter, 652
IntelliSense functions, 77
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
internal management, 720-27
InternalFunction function, 734-35
Internet features, of Excel 2000, 53
interruption of program. See program interruption
Intersect method, 191, 204
Intro worksheet, 547, 710
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
InvoicePrint and Save command, 603
Is operator, 60, 115, 137, 178
IsDate function, 89, 243, 246
IsEmpty function, 89, 243, 246
IsError function, 89, 246
IsMissing function, 103, 246
IsNull function, 89, 235, 243, 246
IsNumeric function, 89, 243, 246
IsObject function, 89, 246
IsRootFolder property, 273, 302
IsXxx functions, 114, 243