E
Effects, using in comment boxes, 277 ‚ 285
Empty values, variants with, 17
Enabled property, 119 ‚ 120
End If statement, 34, 207
EOF (end of file) marker, 181
Error trapping, implications of, 90
Errors, 87 ‚ 90
debugging, 77 ‚ 86
generating when you are testing, 90
types of, 77 ‚ 78
Error-trapping routine, 88
EVAL function, user -defined, 225 ‚ 227
Evaluating a cell , 225 ‚ 227
Events, 10
coding, 7 ‚ 9
listing for a form, 95
that cause problems when debugging, 84
timed, 235 ‚ 236
Excel
as a three- tier application, 125
creating a Word document from within, 161 ‚ 164
driving Microsoft Outlook from, 164 ‚ 166
driving from other Office programs, 166 ‚ 168
interaction with other Office programs, 161 ‚ 168
Visual Basic Editor in, 3 ‚ 10
Excel front end, creating, 125
Excel Object Library, 167
Excel object model, 123 ‚ 168
main objects, 141 ‚ 159
in the Object Browser, 135
object hierarchy, 126, 136 ‚ 138
password exploit, 263
placing another layer in, 193
structure of, 133
Excel spreadsheet, creating from within Word, 166 ‚ 168
Excel spreadsheet screen (standard), 4
Exit Do, within Do Until loop, 41
Exit Sub statement, 244, 261
Explicit declaration of variables , 13
Exponent (^) operator, 69 ‚ 70
Expressions, monitoring, 82 ‚ 83