I
If structure adding Else statement, 143-44 in HideMonths macro, 245 in MoveRight macro, 142-43 nested, 146 overview, 142-43 in PrintOrders macro, 156-58 in SetWindow macro, 287-89 in TestInput macro, 145-46
ignoring errors, 171-74
Immediate window editing SelectChart macro, 80-84 listing methods, 56 listing objects, 55-56 listing properties, 56 separating statements in, 150 typing macro statements, 55-56
Import Data command, 262
Import Data dialog box, 261
ImportFile macro, 27-29
importing Office Data Connection (odc) files, 259-60 text files into Excel, 27-28
indentation, 146
infinite loops, 155
Initialize event, 233-35
InitView macro, 291
InputBox function, 146
Insert UserForm button, 226
Interior object ColorIndex property, 105-7 Color property, 106
Interior property vs. Fill property, 87
Italic button, 117
Item property role in collections, 59 Workbooks object, 63 |