Excel 2007 Power Programming with VBA (Mr. Spreadsheets Bookshelf)
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