103.

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



Microsoft Excel 2002 Visual Basic for Applications Step by Step
FrameMaker 6: Beyond the Basics
ISBN: 735613591
EAN: 2147483647
Year: 2005
Pages: 122
Authors: Lisa Jahred

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net