xlsm project,
138??“139
chart creation, getting started with, 193??“202
Chart object, placing into PowerPoint slide
template, 309
chart placeholder, getting location of, 309
Chart Tools context ribbon, 196
Chart01.xlsm, saving in macro-enabled
format, 193
ChartByRow macro, 201??“202
charting, in Excel 2007, 193??“221
ChartObject objects, 201
ChartObjects.Activate method, activating a
chart with, 201
ChartObjects.Count property, 218
ChartType property, setting chart type using,
201
CheckBox control, in Toolbox window, 38
cHRData class, designing for HRWizard
application, 169??“172
class library project, creating new, 328??“335
class modules, 29??“36
class name, 291
class-based code, benefits of writing, 35??“36
classes, sample and usage, 31??“36
Classes list, in Object Browser, 26
Class_Initialize method, for Employee class,
33
Class_Terminate method, for Employee class,
33
cleanup code
adding to cCustSurvey class module, 141
adding to CreateChartSlidesText
subroutine, 310
adding to GetManagers subroutine, 96
adding to MakeWordDoc subroutine, 293
adding to ThisAddInShutdown method,
337
adding to UserForm1, 144
ClearForm procedure, 144??“145
client code, adding to !Northwind2Excel
Object, 321??“322
cListManager class, adding methods, 169
Close method, adding to btnSave_Click
event, 346
cmdCancel button??™s Click event, adding code
to, 188
cmdPrevious button??™s Click event, 186
cmdSave_Click event, saving employee
record with, 188
code modules
adding to projects, 20??“21
standard, 27??“29
code window
fixing error in, 272
in VBE, 6??“9
variable values shown in, 271??“272
with split panes, 10
colParams collection, filling with
ADODB.
Pages:
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323