Info

CommentFitter2() function,

306 comments centering, 305-306 listing, 303-304 placing charts in, 306-307 resizing, 304-306

computer names, returning,

455-456 ComputerName() function, 455-456

concatenating data, 95-96 conditional formatting array formulas, 129 case study, 128-129 setting up in user interface,

126-127 setting up in VBA, 127

cone charts, 197 Connection object (ADO), 404

constants, 37-41 containers, ChartObject,

176-177 ContainsText() function, 98

content management systems, 344-347 Continue, End, Debug, Help (error message), 467

control tip text, 448 Control Toolbox toolbar, 494

controls accelerator keys, 447 active controls, coloring,

448-450 adding at runtime, 440-443 adding to UserForms,

164-166 assigning macros to, 17-18, 494

ComboBoxes, 166 control tip text, 448 graphics, 168-169 ListBoxes, 166-167 multicolumn ListBoxes, 450 MultiPage, 170-171 option buttons, 167-168 ProgIds, 442-443 RefEdit, 438 scrollbars, 446-447 SpinButtons, 169-170 Tabstrips, 436-438 toggle buttons, 436

converting workbooks to add-ins, 498-500

CopyFromRecordSet() function, 407

copying columns all columns, 227 subset of columns, 228-229 copying and pasting in single statement, 55 data into separate worksheets, 301-302 disabling, 316-318, 328-329 counting directory workbooks, 79 unique values, 88

CountMyWkbks() function, 79

CreateBarOfPie() function, 201

CreateFullMenu() function,

485-486 CreateGroupedMenu() function, 484-485

CreateMemo() function,

372-373 CreateMenu() function, 483

CreateNewQuery() function,

335-336 CreateObject() function, 363

createOneDataBlock()

function, 513 CreatePivot() function, 240-241

CreatePivotTable() function, 239

CreateSimpleMenu() function, 483-484

CreateSummaryReportUsing Pivot() function, 241-243

CreateToolbarO function, 487-490

createWiringDataO function,

508-511 criteria ranges. See ranges Criteria reserved name, 137 CSV (comma-separated value) files, 350 importing, 297-298 reading and parsing, 298-299

CurrentRegion property

(Range object), 70-71 customization charts, 204-205 data transposition, 310-311 delete event, 323-324 functions. See UDFs menus creating, 481-483 deleting, 482-483 fly-out menus, 485-486 menu items, 483-485 objects, 420-422 pivot tables blank cells, deleting,

245-246 number format, 247-249 sort order, 246-247 reports, 373-376 sort order, 318-319 toolbars, 487

buttons, 488-489 creating, 487-488 deleting, 487-488 drop-downs, 489-490 icons, 489

remembering position of, 490-491 Web pages, 343

Customize dialog box, 16-17 CustomSort() function, 319

cut operations, disabling,

316-318, 328-329 cylinder charts, 197

0 0

Post a comment