I

icons, shortcut menus , 773-774

IDE, 859-860

IDE object model, VBProjects collection, 862-864

If-Then constructs, 221-225

If-Then-Else statement, 979

IIf function, 984

Image control

Picture property, 526

UserForms, 417, 510-511

imageMso images, RibbonX code, 741

Immediate window (VBE)

introduction, 141

procedures, 250-251

Implements statement, 979

Import method, 895

Import procedure, 897-898

ImportAFile procedure, 899-900

ImportData procedure, 845

importing

data in text files, 845

objects, Project Explorer, 143-144

text files to ranges, 847-848

ImportRange procedure, 847-848

ImportRange property, 895

Information functions, category, 308

Initialize callback procedure, 743-744

Initialize event, 438, 661

Initialize procedure, 457-458

Input # statement, 844, 979

input boxes, 390

Input function, 984

Input past end of file error, 990

Input statement, 844

InputBox function, 390, 984

InputBox method, 324-326, 392-393

InRange function, 334-335

Insert Function dialog box

function categories, 307-308

function descriptions, 308-310

introduction, 306-307

Insert tab (Ribbon), 728

inserting, class modules, 887

installation, add-ins, 707-708, 721-723

installed version of Excel, 128

InStr function, 984

InStrRev function, 984

Int function, 984

Integer data type, 195, 978, 982

integer portion of number, 983

interactive charts

data for, 625

data ranges, 626-627

introduction, 624

OptionButton controls, 625

interest payment on annuities, 984

interest rate per period, 985

Internal error, 990

internal rate of return on cash flows, 984-985

international applications

country codes, 822-823

date and time settings, 828

International property, 825-828

local properties, 824-825

multilanguage applications, 823-824

system settings, 825-828

VBA language considerations, 824

International property, 825-828

Internet, 41

Internet newsgroups

newsreader access, 973

posting tips, 974

searching, 974

Web browser access, 973-974

interpreted languages, 134

intersecting names , 55

intuitiveness, 124-125

Invalid Clipboard format error, 992

Invalid file format error, 991

Invalid format in resource file error, 991

Invalid ordinal error, 992

Invalid pattern string error, 991

Invalid picture error, 992

Invalid procedure call or argument error, 989

Invalid property array index error, 991

Invalid property value error, 991

Invalid use of Null error, 991

investments, net present value, 985

invoice numbers , 954

IPmt function, 984

IRibbonControl object, 740

IRR function, 984

IsArray function, 984

IsBold function, 362

IsDate function, 984

IsEmpty function, 984

IsError function, 984

IsLike function, 368-369

IsMissing function, 984

IsNull function, 984

ISNUMBER function, 293

IsNumeric function, 984

IsObject function, 984