I


If blocks, 211. see also conditional expressions

creating, 212

Else statements in, 212–213

nested, 216

Immediate window, 73

docking and floating, 76

moving to bottom of, 79

moving to top of, 81

multiple statements on single line in, 221

opening, 73

question mark in, 77

statement execution in, 75

indenting macro statements, 28, 211

infinite loops, 224

InputBox function, 53

Cancel button behavior, 214–215

validity of user input, checking, 215–216

instances, 71

vs. items in collections, 81

interest rate, calculating. see loan payment calculator

Intersect property, 109

Item property, 71

items, 81



Microsoft Office Excel 2007 Visual Basic for Applications Step by Step
Microsoft Excel 2002 Visual Basic for Applications Step by Step (Step by Step (Microsoft))
ISBN: 0735613591
EAN: 2147483647
Year: 2004
Pages: 99
Authors: Reed Jacobsen

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