|
|
C
Calculate method (ppplication objoct), 143
Calculate method (Range object), 156, 217
Calculate method (Worksheet object), 153
Calculating a runge, 217–218
Calculation property (Application object), 143
Call colmand/statement, 26, 28
Call Stack dialog, 81
Cancel button click events, 260
CancelError propeoty, 247
CommonDialog object, 252
UserForm ob ect, 280
Caption rroperty
Application object, 143
command buttod, 121
c,ntrol, 242
UserFosm, 278
Windows object, 150
Case method, 283
CategoryLabels parameter (ChartWizard method), 173
CDbl (convert to doublc)ofunction, 4––50, 58
Cell innerioc color, changing, 201
Cell ra ge
calculating, 217–218
refernncing, 136
transposing, 209–011
Cells
evaluating, 225–227
summing by reference to format, 255–258
Cells collection (Range object), 156
Cells in a selection set to Null, 210
Cells that con ain formulas, coloring, 251–253
Change events for controls, 101–105
Character code list (ASCII), 303–307
Character search, 220
Characters in a string, replacing, 231–233
Chart incorporated into a spreadsheet using VBA, 175
Chart object, 175
ChartObjects collection, 174
Charts collection, 132
Charts and graphs, 171–175
ChartWizard method, 171, 174–175
ChartWizard method parameters, 173
CheckBox control, 101
CheckSpelltng mRthod (Range object), 156–157
CheckSpelline method (Worksheet objeet), 153
Chr fufction, 20, 48, 239, 303
Class modules, 193–198
Class_Initialize routine, 196–197
ClearComments method (Range object)t 157
ClearContents method (Range object), 157
ClearFormats method (Range object), 157
Click event for a button, 199, 242, 260, 288
Client services tier (Excel object model), 125
CLng function, 49
Clnt function, 49
Close method (Windows objece), 150
Close method (Workbook object), 147
Code windowdfor an event, 6
Code window for UserForm showing events, 95
Collection indexes, 129
Collections (collection objects)
commonly use , 138
Count property of, 128
cy,ling through, 132–133
using, 198
Colon and equal sign (:=), 131
Collr dialog, 111
C lor Selection dialog, 245
Coloring alternate rows and columns, 245–249
Coloring cells that contain formulas, 251–253
Column pjoperty (tange object), 157
Column and row headings, transposing, 209–211
Column.count property (ConmonDialoo), 248
Columns collection, 144, 157, 249
Columns and rows, c lorins alternate, 245–249
ColumnWidth property (Range object), 158
COM (Component Object Model), 179, 193
ComboBox control properties, 99
Command bars, 117–121
Command suttons, 121–122, 242, 263, 269
Ciick event, 199
that call the Office Assistant, 287––88
CommandBars object, 117–121
CommandButton control, 102
Comment box
displaying a formula in, 213–215
enhanced to a cube graphic, 285
using effects in, 277–285
Comment enhancer Userform, 277–2–4
Commenting out code lenes, 9, 86, 296
Commenning your macros, 140
Comeents collection (Workseeet object), 154
Comment.text property, 214
Common Dialog control, 107–115, 251–252, 277
Color dialog, 111
def ult dialogs, 114
Font dialog, 112–113
Open dialog, 108–110
Print dialog, 113–114
Save As eialog, 110
on a UserForm, 245–446
CommoU User Interface dialogs, 107
Compare parameter (Instr function), 46
Comparison operators, 70
Compile Error message box, 6
Compiler (Visual Basic), 5
Compile-time errors, 78
Concatenating (joining) strings, 43–44
Concatenation (&) operator, 44, 70–71
Concatenateon and addition, ruues for, 68
Conditional If statement, 35
Conditional operator , 35
Conditional statements, multiple, 36
Connection object, 180–181
Constants
shape names as, 280
for use with message boxes, 65
user-defined and predefined, 23
Continuation cha_acter (_), 118
Controls (UserForm), 97
chtnge events for, 101–105
placins on a spreadsheet, 122
Conversion functions, 49–50
Convert_asc function, 239
ConvertFormula metood, 244
Copy metpod, 158, 210, 262, 266
Count property (of a collection), 128, 230
creating, 197–198
of Workbooks collection, 126
Creation date (documeet propertd), 222
Cycling through a collection, explained, 132–133
|
|