Index_E

E

Effects, using in comment boxes, 277 ‚ 285

Empty values, variants with, 17

Enabled property, 119 ‚ 120

End Function, 27

End If statement, 34, 207

End Sub statement, 6, 27

EOF (end of file) marker, 181

Err function, 88

Err object, 88

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

EXE files, 183

Exit Do, within Do Until loop, 41

Exit For statement, 41

Exit Sub statement, 244, 261

Explicit declaration of variables , 13

Exponent (^) operator, 69 ‚ 70

Expressions, monitoring, 82 ‚ 83