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 312 | Next

Jim DeMarco

"Pro Excel 2007 VBA"

Parameter objects, 84??“85
colReturn collection, adding prm variable to,
85??“86
Column chart type, choosing, 195
nINDEX 352
column headings, adding to worksheet, 337
combo boxes, initializing, 180??“180
ComboBox control, in Toolbox window, 38
command buttons, settings for, 155??“156
Command.Execute method, calling, 86??“87
CommandButton control, in Toolbox
window, 38
content types, in Office documents, 123??“125
[Content_Types]xml file
checking new parts in, 125??“128
for Excel file, 123
controls, adding to forms, 154??“160
copy and paste method, 19
Copy command, copying formulas with, 18
Copy to Clipboard button, in Object Browser,
26
CopyFromRecordset method, 60
ADO error message, 74
counter variable, determining formula
location with, 24
cPerson class module
adding call to ID Property Let function,
162??“163
adding read-only FullName property to,
164??“165
adding to project, 161
adding variable declarations to, 161??“162
finishing, 163??“164
initializing and setting defaults, 162
Create PivotTable dialog box, sections in,
224??“225
CreateChartSlides subroutine, creating,
302??“304
CreateChartSlidesText subroutine
adding cleanup code to, 310
adding variable declarations to, 308??“309
coding, 308??“313
CreateObject function, 291??“292
CreatePivotTable method, 230??“231
CreateTitleSlide subroutine, creating,
300??“302
cStep class module, 172??“173
cStepManager class module
adding properties to, 174??“175
designing to manage steps, 173??“178
properties table, 175
Ctrl-drag, using fill handle with, 18
CurrentMapName() method, adding to cXML
class module, 112
CurrentRegion property, 237
currReturn variable, checking value of, 283
Custom Lists dialog box, 206
custom macros, adding ribbon to run,
128??“129
Customer Survey database, saving data to,
133??“139
Customer Survey form, launching, 147
customUI .


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