Assert method, sample subroutine
using, 260
Debug.Print method, 258??“260
nINDEX 353
DebugExample01.xlsm file
copying Debug.Assert subroutine into, 260
downloading and opening, 254
trapping type mismatch error in, 278??“279
Debugger??™s toolkit, 249??“275
debugging and error handling, 249??“285
inserting breakpoint in code, 263
loops, 258
sample code for, 262
VBE tools for simple, 253??“260
Department combo box, bound to named
range, 182
Details pane, in Object Browser, 27
Developer ribbon, code options on, 3
Developer tab, displaying, 3
DisplayName property, fixing error fired by,
47??“48
DLL, using in project, 321
DoClearSheet() subroutine, creating, 95
docProps folder, for Excel file, 125
DoHeadings method, adding titles to
worksheet with, 346??“347
Dynamic PivotTable, creation code for, 234
nE
Edit Series dialog box, 208??“209
EmpData database worksheet
sample input values and saved data,
189??“191
sections in, 151??“152
employee data, adding to worksheet, 338
Employee data type, 36
employee record, saving, 187??“188
encapsulation, 30
equipment information page, adding
controls to, 158
equipment tab control settings, table of, 158
error handling, 275??“285. See also debugging
and error handling; exception
handling
breakpoint added in, 282
debugging error handler, 282
enabling for GetSalesTotal function, 279
rules to live by, 278
setting up procedure for, 279
trapping specific errors, 278??“282
type mismatch error, 280??“281
error messages, File Not Found, 278
Excel, checking version of, 74
Excel 2007
adding custom ribbon to workbook,
119??“131
adding ribbon to run custom macros,
128??“129
and ADO recordsets, 74
changing code to classes in, 87??“96
charting in, 193??“221
data import tools, 43??“54
default charting behavior, 196
importing XML into, 99??“106
in the .
Pages:
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324