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 |