SEARCH
0-9 A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
Prev | Current Page 310 | Next

Jim DeMarco

"Pro Excel 2007 VBA"

Print, 258
with MsgBox debugging, 256
blank data records, effect on PivotTable
report, 238??“242
break line text, at breakpoint, 263??“267
break mode, checking variables in, 267??“275
breakpoint, inserting in code for debugging,
263
Index
351
nC
cAccess class module
adding to project, 161
code for, 168
cAddress class module
adding to project, 161
code for, 165
call stack feature, 270??“271
Call Stack window, opening, 270
Cancel button, coding, 348
Cancel command button, code for
Userform1, 147
Candy chart, testing code for, 220??“221
cCustSurvey class module, 140??“142
coding into UserForm, 143??“150
creating, 139??“143
creating Save method in, 142??“143
validation results, 148
cData class, code from ActiveX component,
318??“319
cData class module
creating, 90??“95
creating GetData function for, 91
creating in VBE, 88
initialization and termination methods, 92
cData objects, using, 95??“96
cds.xml file, opening and adding new title to,
105
cEmployee class
adding Property Let and Get functions,
31??“32
assigning property values, 34??“35
creating, 31??“33
using, 33??“36
cEquipment class module
adding to project, 161
code for, 167
cExcelNwind class, code from ActiveX
component, 319
cExcelSetup class module
adding setup and cleanup functionality, 89
code for, 92
creating in VBE, 88
setting and retrieving property values,
89??“90
working with, 89??“90
cExcelSetup objects, using, 95??“96
cExcelUtils class
exporting file with new addition, 150
exporting to UserForm.


Pages:
298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322