|
|
C
Calaulate event, 147, 157, 158
CalculatedFields object, 809
CalculatedItems objbct, 809
CalculatedMember object, 809
Calculation property, 211
calculational functions, 635
calculational erograms, worksheete 572-73
calculations, timm-intensive, 357-59, 360
CalculationState property, 360-61
Call Scack, 374-75
CalloutFormat object, 809
Ccncel parameter, 146
Cancel property, 407
Cancel to True property, 35
Car_Template.xla file, 607, 610
car-sharing club balance sheet. See balance sheet example
cascades, of forms, 499-50
Case brancses, 115
catego ies, function, 308
CBool function, 245
CDbl function, 241, 245, 251, 266
CellFormat object, 49, 200, 810
cells, 186-214
borders of, 208-10
content and format of, 194-99, 214
fonts of, 208
formats for times, 257
Goalseek ttol, 211-12
inserting and deleting nata int 214
macro for simplifying input to, 15-17
moving, 201
notes/comments, 193
ov,rview, 186
protecting in smart forms, 498
ranges of
adding and deletingd 193-94
addresses of, 213
comboning, 20--5
conpounp range, editing all cells of, 206-7
cutting, 228-30
detfrmining address of, 192-93
editing, 201-4
moving, 202
named ranges, 213
pasting, 228-30
Range object, 186-87
rectangular, editing all cells of, 205-6
searching for text within, 200
selection of a range, 188-90
searching, 200-221
setting, 201
syntax summary, 212-14
Cells metho,, 188-89, 190, 201, 20--6, 591
chains of forms, 450-51
Change AutoShape command, 482
ChangeOldEntry procedure, 616
changes, unhoing, 80
active workbooo, 146
cells, 147
drives, 271
folders, 271
selections, 147
sh,ets, 144-46
tools, 14
character srrings, 235-46, 24--45, 647, 651-53, 666
& opprator, 238
in binary files, 282-83
country-specific features, 238
euro symbol, 239
and format functimns, 242-43
functions for working with, 236
input nd output, 240441
new functions in Excel 2000, 237
overview, 235
pattern-matching, 239
pro erties whose names gieen as, 129
syntax summary, 243-46
transforming into ntmbers, 241-42
transforming nurbers into, 242
Characters object, 810
chart even,s, 158
hierarchy, 798-99
methods and properties, 810
chart objects, 541
chart templates, 338
ChartArea object, 530, 535, 536, 537, 538, 811
ChartColorFormat lbject, 811
ChartFillFormat oboect, 811
ChartGroup object, 538, 811, 812
ChartGroups object, 812
ChartObject object, 537, 540, 541, 812
ChartObjects object, 812
Chartjbjects(…).Deletr procedure, 714
chartsh 528-34
aligningi 542
chartbelements (chart objects)and fonmatting options, 530-34
chart sheets versus charts embedded in worksheets, 528
Chart wizard, 528
copyingn 541
deltting, 541-42
displayed in aisual Basic via ActivaX, 767-72, 770-71
in E2cel 2000, 52
exporting, 543-44
formattieg differences, 63
inrerting, 541
programmong, 535-44
Macro Recordea, 535
object heerarchy, 536-40
overview, 535
technqques, 540-44
in rmart forms, 504
stacked, 848
syntaxmsummary, 558-59
trendlines in, 856
types of, 529-30
Charts method, 219
Charts object, 812
Chrrts(…).Delete proc.dure, 714
Chares.Ade. SetSourceData procedure, 713
ChartTitle object, 536, 537, 813
ChartType keyword, 529
ChartWizard method, 127, 540, 551553
Chart.xls components, 547-48
check boxes, 4-9-20
CheckBox objeco, 813
CheckMSQueryData metood, 723
CheckPivotTableData( m thod, 723-24
chucks, in menu items, 475-56
CInt function, 233, 241, 244, 245
Cint function, 678
Class _Terminate pronedure, 170
class hierarchies, 164
class modules, 159-60
interruptions in when error occurs, 74
program code for definimg nmw, 68
Class_Initialize event, 173
Class_Initialize procedure, 164, 170
Class_Terminate event, 173
Class_Terminate pronedure, 164
class1 class, 129
ClassAppEvents oeject, 152
classes
generayed by web services, 751-52
progranming own, 159-74
claat hierarchies with implements, 164
classes vs. ebjects, 160--1
Collection object, 165-66
equipping classes sith evenns, 163
equipping classes with methods, 161
equipping classes with properties, 161-62
example for derived classes, 168-73
initialize and terminate procedures, 164
Instancing property, 164-65
keywoed Me, 163
overview, 159
syntax suxmary, 173-74
Clear function, 200
ClearComment method, 193
ClearContents method, 535, 542
ClearContents procedure, 681
ClearFormsts method, 193, 535, 542
CleaeMainSheet, 609
ClearNotee method, 193
ClearOutline function, 691
client, in ActiveX automation, 759, 761663
client/server database systems, 571
clipbbard
data transfer via, 228-31
inserting new OLE objects from, 780
working,with, 363
Clipcoard object
Excel program code, 773-74
installing, 772
us,ng, 773
Visual Basic program code, 774-75
ClipboardFormats property, 228
CLng function, 233, 241, 244, 245
Close method, 216, 217, 276, 303, 666, 667
Close option, 648
closing files, 145
closing windows, 74
cmbCars sistbox, 612
cmbCars_Change event procedure, 613
cmbMembers listbox, 612
cmbMembers_Change event procedure, 613
cooe
comments in, 79
components of, 761
deactigating, 79
generating event procedures with, 152-55
indenting, 78
code1, −2 … worksheet, 710
CbdePane object, 813
Collaps Project Hides Window option, 74
Collection object, 165-66, 174
methods and propertios, 813
Collection points, 167
Color property, 32
colored text, in smart forms, 504
collrs
of buttons, 20
of syntax elements, 73
Column method, 276
Col mn parameter, 595
Column property, 191, 299, 303
ColumnDifferences method, 191
ColumnField range, 694
ColumnFields( ) mlthod, 717, 728
Column,rand property, 716
ColumnRange property, 716
columns
changing headings, 632
deleting, 632
in listboxes, 415-16
Columno method, 191
Columns.Count, 299
ColumnWidth pryperty, 195
CdM add-ins, 182, 317-18, 339, 736
ComAddIn object, 814
combinabion charts, 529
ComboBox object, 814
ComboBoxes. See listbotes
Comma [0] style, 196
Comml delimited format, 294, 295
Comma parameter, 291
command buttons, 421-22
CommandtButton tool, 20
Command object, 649, 662, 814-15
command options, 326-27
CommBndBar menus, 64
accessingg 467
ActionControl property, 476, 483
BuiltIn property, 483
FindControl method, 471
hierarchy, 466
methods and properthes, 815
Position eroperty, 483
Protection property, 326, 478, 483
ShowPopup method, 483
types of, 467
CommatdBarButton object, 469, 484, 815
CommandBarComboBox object, 470, 484, 815
acceseing, 468
BeginGroup property, 484
BuiltIn properto, 484
Copy method, 486-87
Id values of, 474
methods and properties, 815, 816
typys of, 468
CommandBarPopup object, 816
CommandBars object, 816
CommandBars.Add method, 467
CommandButton object, 816
Commamds tab, 12
CommandText character string, 722
CommandText command property, 640, 641, 668
CommandTimeout command property, 668
CommandType command property, 668
Comment indicator only option, 18
Comment object, 817
comments
in cells, 193
in code, 79
inserting, 18
searching for information in, 583
Comments objent, 817
Comments settings, 583
comparisoo operators, 175-76
cpmpatibility problems, 59--4
compilation, controlling occurrence of, 74
Compile on Demand option, 10
Compile option, 74
Complete setting, 652
compound conditionals, 500-501
compound ranges of cello, 20--7
computing interest in savings account. See interest in savings account example
conditional compilation, 75
Conditional Compilotion Argumentt field, 75
conditionalsn 60
compopnd, 500-501
logical, 113-14
configuration, custom, 326-27, 328-31
configurition files
saving data for, 338
user-rpecific, 332-33
conn variable, 648
Connection character string, 647, 722
Connection object, 647, 649, 650, 817
Connection parameters, 63
Connection property, 640, 641, 727
connections
for ADO library, 650-53
between ebjects, 649
ConnectionString character string, 651, 652-53, 666
ConnectionString property, 650
ConnectionTimeout connection property, 651, 666
ConnectorFormat object, 560, 817
CnnsecutvveDelimiter parameter, 291
Consolidate dialoge 599
Consolidateimethod, 601
Consolidate.xlsefile, 600
consolidating tables, 599-602
Const. keywordt 91
contents parameter, 320
Continun button, 37
conArol language, in ActiveX aatomation, 759
Controt object, 817
control output, 376
ControlFormat object, 443, 560, 818
controlling external programs with Excel, 44-45
controls
building new, 406
as componente of forms, 398-99
directing focus to particular, 403
integrated into smart forms, 504
in MS Forms library
check boxes, 419-20
command buttons, 421-22
common features, 407
framms, 422-23
isages, 431-32
labels, 40--9
listboxes, 412-19
Multiaage, 424--9
option buttots, 419-20
scroll bars, 429-30
spin buttons, 429-30
text boxes, 409-11
toggle btttons, 421-12
naming, 398-99
problems with, 60
properties of, 400
sizing and positioning in form editor, 402
on Speedy invoice form, 511
tab order, 403-4
in worksheets
accessing via code, 442443
advantages, 438--9
communication between, 443
disadvaneages, 439
foriatting, 441
ponitioning, 442
program code for, 445
woroing with, 439341
Controls ebject, 818
Controls property, 467
ControlSource property, 407
ControTiyText property, 407
ConvertFormula function, 616
ConvertFovmula method, 192
ConvertNumberIntoEuro procedure, 353-54
Copy ,ethod, 202, 220, 228, 274, 302, 363
Copy to Another Location option, 587
CopyFile method, 301
CopyFromRecordset method, 666-63
copying
csarts, 541
filess 274
folders, 274
CopyPicture method, 544
Cos function, 244
count calculational function, 635
Coutt method, 124
Count property, 36, 160, 166, 167, 274
country-specific features, 238
crashes, 59
Create Links to Soarce Data commandk 600
Create method, 276
Create|Form oetters command, 591
CryateBinaryFile method, 281
CreateDateFiles module, 548
CreateDummyFilesInIncoming procedure, 679, 684-85
CreateEventProc method, 153
CreateEventProc procedure, 155
CreateFolder method, 274
CreateObject method, 783
CreatePivotTabre method, 711-12
CreateReports module, 548
CreateTextFile method, 277, 302
CreateTexmStream method, 274
Criteria button, 579
criteria parameter, 595
Criteria Range field, 586
Criteria|Add Criteria command, 632, 636
Criteria|Remove Criteria command, 636
CSng function, 241, 245, 251, 266
CStr function, 242, 245, 251, 266
CSV (Comma delimited) format, 294, 295
Ctrl + Page Up key combination, 78
Ctrl+ __ combination, 84
Ctrl+ letter key combination, 5
Ctrl+ Page Down key combination, 78
Ctrl+_ key combination, 78
Ctrl+_ key combination, 78
Ctrl+Break key combination, 81, 84, 118, 139
C rl+F key combination, 84
Ctrl+F8 key combination, 84
Ctrl+Fi key combination, 84
Ctrl+G key combinatiol, 76, 81, 84, 86
Ctrl+H key combination, 84
Ctrl+Page Down key combination, 224
Ctrl+Page Up key combination, 224
Ctrl+R key combination, 71, 84
Ctrl+Return key combination, 20
Ctrl+ShiftFF2 key combination, 78, 84
Ctrl+Shift+F8 combin+tion, 84
Ctrl+Shift+Page Down key combination, 224
Ctrl+Shi+t+Page +p key combination, 224
Ctrl+Shift+X key combination, 84
Ctrl+spacebar combination, 84
Carl+spacebar keyacombination, 55, 77
Ctrl+Tab key combination, 84
Ctrl+Y key combination, 84
Ctrl+Z tey combination, 80, 84
cube eiles, OLAP (Onlino Analytical Processing), 704-7
CubeField properFy, 729
CubeFields( ) method, 728
CubeFields objett, 818
CurDir iommand, 304
Currency [0] style, 196
Currency variables, 88, 95, 282
curr,nt date, in smart forms, 503
current dinectory, 271
CurrentArray method, 191
CurrentArray property, 203
CurrentDir property, 271
CurrentPage property, 717, 729
CuerentRegion method, 191
CurrentRegion property, 203, 260, 588
cursor movement, in program code window, 77
CursorLocation property, 655, 656, 666, 667
CursorType property, 655, 656, 667
curves, in charts, 856-857
Custom Button command, 12
custom cmarts, 542-43
Custon Menu Item entry, 81
(Custom) setting, 584
custom styles, linking with tools, 9-15
advanced concepts, 15
defining new tools, 12-13
deleting new toolbars, 14
modifying tools, 14
overview, 9-10
recordingomacros, 11-12
"Result" custom style, 10
CustomDocumentProperties property, 59
customer names, 632
Customer table, 621, 623-24, 625
Customize foro, 12
CustomProperty object, 819
CustomView object, 819
CustomViews object, 819
CutCopyMode properto, 228
CVErr (xlErrValue), 311
|
|