Ydn

early binding, 359-361

Edit Watch command

(Debug menu), 50 Edit Watch dialog box, 50 editor. See VBE electrical control system case study addAConnection() function,

512-515 addMSlash() function, 514 addWiringWSTag()

function, 510 changeAConnection()

function, 512 cloneDataBlocks() function, 513

createOneDataBlock()

function, 513 createWiringData() function, 508-511

deleteAConnection() function, 512, 515 ExcelCoords type, 509 global constants, 510 goals, 506

initializeSystem() function, 509

resetFormatting() function, 513

resetValue() function, 515 solution, 506-507 summary, 516 WiringToExcelCoords()

function, 509 Workbook_SheetChange()

function, 508, 511-512 Workbook_SheetSelection Change() function, 511-512 XLtoWiringCoords() function, 509

Elevation property (charts), 198

email addresses, validating, 82-83

embedded charts, 153

changing to ChartSheets, 181

ChartObject container,

176-177 compared to ChartSheets, 176

event trapping, 418-419

EmpAddCollection() function, 426-427

EmpPay() function, 421

EmpPayCollection() function, 424

empty cells, checking for, 69-70

empty tags (XML), 350

emptying arrays, 382-383 EmpWeeklyPayO function, 420

EnableAllClear() function,

328-329 EnableControl() function, 329

enabling digital signatures, 19 events, 142 encountering errors on purpose, 474

EndKey function, 367 EnterArrayFormulas function, 129

Err object, 472 error bars, 193-195

error handling alerts, turning off, 473-474 client training, 474-475 code protection, 477-478 Continue, End, Debug,

Help error message, 467 Debug button, 467-470 encountering errors on purpose, 474 Err object, 472 File not loaded completely, 394

ignoring errors, 472-473 multiple error handlers, 472 On Error GoTo, 470-471 On Error Resume Next,

472-473 page setup problems, 473 password checking, 477-478 Runtime Error 9, 475-476 Runtime Error 1004,

476-477 version problems, 478-479

ErrorBar object, 193-195 Evaluate() function, 136 EventHack() function, 324 events. See also names of individual events accessing from VBA Object and Procedure dropdown, 141-142 enabling, 142 parameters, 142 trapping application events,

416-418 embedded chart events, 418-419

EveryOtherRow() function, 381

Excel 97 pivot tables, 288-289

Excel Tips and Tricks Web site, 301 ExcelCoords type, 509

ExcelXButton() function, 458

executive overviews, creating, 271-274

existence of fields. checking for, 412-413 existence of tables, checking for, 411-412

Exit For clause, 107 exiting

exporting charts as images, 202-203 to Word, 302-303 Export_Data_Word_Table() function, 302-303

Extensible Markup

Language. See XML Extract reserved name, 137

0 0

Post a comment