83.

E

editing macros

85

Edit OLE DB Query dialog box, 264

Edit WordArt Text dialog box, 276

ElseIf statement, 199

Else statement, If structure

embedded charts

creating, 78-79

modifying, 79-80

referencing, 80-84

enabling macros, 19-22

End If statement, If structure

End With statement, 118

Enterprise Information System (EIS)

introductory animation, 258

opening, 258

viewing application, 256-58

viewing quarterly orders, including graph, 256-57

viewing table and map, 258

EntireColumn property, 102

EntireRow property, 102

enumerated lists, 104

equal sign (=), 17

Err object

in CheckFiles macro, 179-80

Clear method, 177

in MakeNextReport macro, 178

Number property, 178

overview, 175

errors

compiler, 170

ignoring, 171-74

logic, 170

run-time, 170-81

seeking via Err object, 175-78

syntax, 170

trapping, 178-81

types of, 170

event handlers

ActiveX controls and, 279

adding mouse movement functionality, 198-200

btnZoomIn_Click macro, 196-97

btnZoomOut_Click macro, 198

btnZoomOut_MouseMove macro, 198-200

canceling, 207

creating via View Code button, 196-97

creating via Visual Basic Editor, 197-98

linking command buttons to, 196-97

and macros, 279

suppressing, 205-7

in Visual Basic projects, 200-202

at workbook level, 204-5

Workbook_Open macro, 291

workbook storage, 200-202

at worksheet level, 202-4

events

canceling, 207

Click, 198

for command buttons, 202

DblClick, 198

MouseMove, 198-99

Open, 204

SelectionChange, 202-4

workbook default, 204

worksheet default, 203

Excel. See Microsoft Excel

Exit Design Mode button, 215

ExitEIS macro, 291-92

ExitView macro, 292

external databases. See databases