Index_C

C

Calculate event, 147, 157, 158

CalculatedFields object, 809

CalculatedItems object, 809

CalculatedMember object, 809

Calculation property, 211

calculational functions, 635

calculational programs, worksheet, 572-73

calculations, time- intensive , 357-59, 360

CalculationState property, 360-61

calendars, 40, 262-65

Call Stack, 374-75

CallByName method, 51, 129

CalloutFormat object, 809

Cancel parameter, 146

Cancel property, 407

Cancel to True property, 35

CancelUpdate method, 661, 667

Caption property, 218, 469

Car_Template.xlt file, 607, 610

car-sharing club balance sheet. See balance sheet example

cascades, of forms, 449-50

Case branches, 115

categories, function, 308

CBool function, 245

CCur function, 241, 245

CDate function, 245, 248, 251

CDbl function, 241, 245, 251, 266

CellFormat object, 49, 200, 810

cells , 186-214

accessing, 190-91, 213

borders of, 208-10

content and format of, 194-99, 214

fonts of, 208

formats for times, 257

Goalseek tool, 211-12

inserting and deleting data in, 214

macro for simplifying input to, 15-17

moving, 201

notes/comments, 193

overview, 186

protecting in smart forms, 498

ranges of

accessing, 187-88, 190-91

adding and deleting, 193-94

addresses of, 213

combining, 204-5

compound range, editing all cells of, 206-7

copying, 202, 228-30

cutting, 228-30

determining 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

selecting, 201-4, 213

selection of a range, 188-90

searching, 200-201

setting, 201

syntax summary, 212-14

Cells method, 188-89, 190, 201, 205-6, 591

chains of forms, 450-51

Change AutoShape command, 482

Change event, 147, 157, 410

ChangeOldEntry procedure, 616

changes, undoing, 80

changing

active workbook, 146

cells, 147

drives , 271

folders, 271

selections, 147

sheets, 145-46

tools, 14

character strings, 235-46, 244-45, 647, 651-53, 666

& operator, 238

in binary files, 282-83

comparison of, 238, 240

country-specific features, 238

euro symbol, 239

and format functions, 242-43

functions for working with, 236

input and output, 240-41

new functions in Excel 2000, 237

overview, 235

pattern-matching , 239

properties whose names given as, 129

syntax summary, 243-46

transforming into numbers , 241-42

transforming numbers into, 242

Characters method, 194, 207

Characters object, 810

chart events, 158

Chart object, 151, 537, 538

hierarchy, 798-99

methods and properties, 810

chart objects, 541

chart templates, 338

ChartArea object, 530, 535, 536, 537, 538, 811

ChartColorFormat object, 811

ChartFillFormat object, 811

ChartGroup object, 538, 811, 812

ChartGroups object, 812

ChartObject object, 537, 540, 541, 812

ChartObjects object, 812

ChartObjects( ).Delete procedure, 714

charts , 528-34

aligning, 542

chart elements (chart objects)and formatting options, 530-34

chart sheets versus charts embedded in worksheets, 528

Chart wizard, 528

copying, 541

deleting, 541-42

displayed in Visual Basic via ActiveX, 767-72, 770-71

in Excel 2000, 52

exporting, 543-44

formatting differences, 63

inserting, 541

printing, 534, 543-44

programming, 535-44

Macro Recorder, 535

object hierarchy, 536-40

overview, 535

techniques, 540-44

in smart forms, 504

stacked , 848

syntax summary, 558-59

trendlines in, 856

types of, 529-30

Charts method, 219

Charts object, 812

Charts( ).Delete procedure, 714

Charts.Add. SetSourceData procedure, 713

ChartTitle object, 536, 537, 813

ChartType keyword, 529

ChartWizard method, 127, 540, 551-53

Chart.xls components , 547-48

ChDir command, 271, 304

ChDrive command, 271, 304

check boxes, 419-20

CheckBox object, 813

CheckMSQueryData method, 723

CheckPivotTableData( ) method, 723-24

checks, in menu items, 475-76

Chr function, 242, 246, 300

CInt function, 233, 241, 244, 245

Cint function, 678

Class _Terminate procedure, 170

class hierarchies, 164

class modules, 159-60

in Excel 97, 55

interruptions in when error occurs, 74

program code for defining new, 68

Class_Initialize event, 173

Class_Initialize procedure, 164, 170

Class_Terminate event, 173

Class_Terminate procedure, 164

class1 class, 129

ClassAppEvents object, 152

classes

generated by web services, 751-52

programming own, 159-74

class hierarchies with implements, 164

class modules, 159-60, 167-68

classes vs. objects, 160-61

Collection object, 165-66

equipping classes with events, 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

keyword Me, 163

overview, 159

syntax summary, 173-74

Clear function, 200

Clear method, 193, 542

ClearComment method, 193

ClearContents method, 535, 542

ClearContents procedure, 681

ClearFormats method, 193, 535, 542

ClearMainSheet, 609

ClearNotes method, 193

ClearOutline function, 691

client, in ActiveX automation, 759, 761-63

client/server database systems, 571

clipboard

data transfer via, 228-31

inserting new OLE objects from, 780

working with, 363

ClipBoard object

Excel program code, 773-74

installing, 772

using, 773

Visual Basic program code, 774-75

ClipboardFormats property, 228

CLng function, 233, 241, 244, 245

Close command, 278, 279, 305

Close method, 216, 217, 276, 303, 666, 667

Close option, 648

closing files, 145

closing windows , 74

cmbCars listbox, 612

cmbCars_Change event procedure, 613

cmbMembers listbox, 612

cmbMembers_Change event procedure, 613

code

comments in, 79

components of, 761

deactivating , 79

generating event procedures with, 152-55

indenting, 78

code1, ˆ’ 2 worksheet, 710

CodeModule object, 153, 813

CodePane object, 813

Collaps Project Hides Window option, 74

Collection object, 165-66, 174

in Excel 97, 56

methods and properties, 813

Collection points, 167

Color property, 32

colored text, in smart forms, 504

ColorFormat object, 563, 814

colors

of buttons , 20

of syntax elements, 73

Column method, 276

Column parameter, 595

Column property, 191, 299, 303

ColumnDifferences method, 191

ColumnField range, 694

ColumnFields( ) method, 717, 728

ColumnGrand property, 716

ColumnRange property, 716

columns

changing headings, 632

deleting, 632

in listboxes, 415-16

Columns method, 191

Columns.Count, 299

ColumnWidth property, 195

COM add-ins, 182, 317-18, 339, 736

ComAddIn object, 814

combination charts, 529

ComboBox object, 814

ComboBoxes. See listboxes

Comma [0] style, 196

Comma delimited format, 294, 295

Comma parameter, 291

Comma style, 196, 197

command buttons, 421-22

Command Button tool, 20

Command object, 649, 662, 814-15

command options, 326-27

CommandBar menus , 64

CommandBar object, 147, 556

accessing, 467

ActionControl property, 476, 483

BuiltIn property, 483

in Excel 97, 59

FindControl method, 471

hierarchy, 466

methods and properties, 815

Position property, 483

Protection property, 326, 478, 483

ShowPopup method, 483

types of, 467

Visible property, 473, 483

CommandBarButton object, 469, 484, 815

CommandBarComboBox object, 470, 484, 815

CommandBarControls object

accessing, 468

BeginGroup property, 484

BuiltIn property, 484

Copy method, 486-87

Id values of, 474

methods and properties, 815, 816

types of, 468

CommandBarPopup object, 816

CommandBars object, 816

CommandBars.Add method, 467

CommandButton object, 816

Commands 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 object, 817

Comments settings, 583

comparison operators, 175-76

compatibility problems, 59-64

compilation, controlling occurrence of, 74

Compile on Demand option, 10

Compile option, 74

Complete setting, 652

compound conditionals, 500-501

compound ranges of cells, 206-7

computing interest in savings account. See interest in savings account example

conditional compilation, 75

Conditional Compilation Arguments field, 75

conditionals, 60

compound, 500-501

logical, 113-14

configuration, custom, 326-27, 328-31

configuration files

in Excel {0}97, 61-62

in Excel 2000, 54, 61-62

saving data for, 338

user -specific , 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 objects, 649

ConnectionString character string, 651, 652-53, 666

ConnectionString property, 650

ConnectionTimeout connection property, 651, 666

ConnectorFormat object, 560, 817

ConsecutiveDelimiter parameter, 291

Consolidate dialog, 599

Consolidate method, 601

Consolidate.xls file, 600

consolidating tables, 599-602

Const. keyword, 91

constants, 91, 95-96

contents parameter, 320

Continue button, 37

control language, in ActiveX automation, 759

Control object, 817

control output, 376

control toolbox, 20, 21

ControlFormat object, 443, 560, 818

controlling external programs with Excel, 44-45

controls

ActiveX, 404-5, 432-34

building new, 406

as components 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

frames , 422-23

images, 431-32

labels, 408-9

listboxes, 412-19

MultiPage, 424-29

option buttons, 419-20

scroll bars, 429-30

spin buttons, 429-30

text boxes, 409-11

toggle buttons, 421-22

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, 442-43

advantages, 438-39

communication between, 443

disadvantages, 439

formatting, 441

positioning, 442

program code for, 445

working with, 439-41

Controls object, 818

Controls property, 467

Controls.Add method, 469, 471

ControlSource property, 407

ControTipText property, 407

ConvertFormula function, 616

ConvertFormula method, 192

ConvertNumberIntoEuro procedure, 353-54

coordinate axes, 52, 531

Copy method, 202, 220, 228, 274, 302, 363

Copy to Another Location option, 587

CopyFile method, 301

CopyFromRecordset method, 662-63

copying

cells, 202, 228-30

charts, 541

files, 274

folders, 274

CopyPicture method, 544

Corners object, 530, 536, 818

Cos function, 244

count calculational function, 635

Count method, 124

Count property, 36, 160, 166, 167, 274

country-specific features, 238

crashes, 59

Create Links to Source Data command, 600

Create method, 276

CreateForm Letters command, 591

CreateBinaryFile method, 281

CreateDateFiles module, 548

CreateDummyFilesInIncoming procedure, 679, 684-85

CreateEventProc method, 153

CreateEventProc procedure, 155

CreateFolder method, 274

CreateObject method, 783

CreatePivotTable method, 711-12

CreateReports module, 548

CreateTextFile method, 277, 302

CreateTextStream method, 274

Criteria button, 579

criteria parameter, 595

Criteria Range field, 586

CriteriaAdd Criteria command, 632, 636

CriteriaRemove 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

Ctrl+F key combination, 84

Ctrl+F8 key combination, 84

Ctrl+F9 key combination, 84

Ctrl+G key combination, 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+Shift+F2 key combination, 78, 84

Ctrl+Shift+F8 combination, 84

Ctrl+Shift+Page Down key combination, 224

Ctrl+Shift+Page Up key combination, 224

Ctrl+Shift+X key combination, 84

Ctrl+spacebar combination, 84

Ctrl+spacebar key combination, 55, 77

Ctrl+Tab key combination, 84

Ctrl+Y key combination, 84

Ctrl+Z key combination, 80, 84

cube files, OLAP (Online Analytical Processing), 704-7

CubeField object, 717, 818

CubeField property, 729

CubeFields( ) method, 728

CubeFields object, 818

CurDir command, 304

Currency [0] style, 196

Currency style, 196, 197, 199

Currency variables , 88, 95, 282

current date, in smart forms, 503

current directory, 271

CurrentArray method, 191

CurrentArray property, 203

CurrentDir property, 271

CurrentPage property, 717, 729

CurrentRegion 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 charts, 542-43

custom data types, 90-91, 96

Custom 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

recording macros, 11-12

"Result" custom style, 10

CustomDocumentProperties property, 59

customer names, 632

Customer table, 621, 623-24, 625

Customize form, 12

CustomProperty object, 819

CustomView object, 819

CustomViews object, 819

Cut method, 202, 228

CutCopyMode property, 228

cutting cells, 202, 228-30

CVErr function, 384, 386

CVErr (xlErrValue), 311