csv
data imported from, 51
with Comma selected as delimiter, 49
with Tab selected as delimiter, 49
MakeBeverageSalesChart macro
looking at code, 198??“202
modified version, 201
recording, 193??“194
MakeDynamicPivotTable subroutine,
creating, 233??“235
MakePieChart macro
for creating pie chart, 206
modifying for Beverage category sales
info, 212??“213
MakePieChart2 macro, creating and running,
212??“213
MakePivotTable macro
adding new worksheet to workbook in,
230
code for, 229??“235
error generated by, 232??“233
saving as macro-enabled workbook, 232
MakePowerPointPresentation subroutine
adding text to chart slides, 308??“313
completing, 304??“306
creating, 300
modifying and running calling procedure,
312??“313
running the code, 306??“308
MakeWordDoc subroutine
adding charts to the report, 295??“298
creating, 291??“295
finished code for, 296??“297
managed code, in an Excel project, 327??“349
message boxes, displaying information with,
253??“257
???Members of??? list, in Object Browser, 26
Microsoft Office object types, 291??“292
Microsoft tools, for creating Excel projects
within VS 2005, 323??“327
Microsoft Windows Vista, running examples
on, 43
Monthly Total Sales Amount worksheet,
activating, 193??“194
MsgBox debugging, BirthYear function with,
256??“256
MsgBox function
arguments list, 255
creating message boxes with, 255??“257
MultiPage control
adding command buttons to, 155
determining what next page should be,
185
hiding all pages except for first, 181
in Toolbox window, 38
inserting new page in, 153??“154
setting Value property, 180??“181
MultiPage1 control??™s Change event, 186
nN
navigation, adding to HRWizard UserForm,
183??“186
.
Pages:
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324