Info Rbl

ChartObject container,

176-177 ChartSheets, 178

changing embedded charts to, 181 compared to embedded charts, 176 colors, 186 Column charts, 195 cone charts, 197 creating, 178-181 Add function, 179 Location function, 180-181 SetSourceData function, 179

custom charts, 204-205 cylinder charts, 197 data labels, 191-192 data series, 188-189 data tables, 192-193 default chart type, 181-182 doughnut charts, 196 embedded charts, 153 changing to

ChartSheets, 181 ChartObject container,

176-177 compared to

ChartSheets, 176 events, 418-419 error bars, 193-195 events, 201-202 exporting as images,

202-203 gridlines, 191 hierarchical donut chart, 205

interactive charts, 201-202 legends, 192-193 line charts, 196 object variables, 182-183 objects, sizing and positioning, 186-187 pie charts, 196, 199-201 placing in comments,

306-307 plot area, 186-188 pyramid charts, 197 scatter charts, 196, 203 speedometer chart, 204 stock quote charts, 197 supply curve chart, 205 surface, 197 table of chart types,

195-198 titles, 192-193 trendlines, 193-195

ChartSheets, 178

changing embedded charts to, 181 compared to embedded charts, 176

ChartTitle object, 192-193 CheckActiveCtrlO function, 449

CheckDisplayRes() function, 457

CheckUserRights() function, 80

Class Module command

(Insert menu), 415 class modules, 20

collections, creating,

425-427 custom objects creating, 420-421 referencing, 421-422 events, trapping application events,

416-418 embedded chart events, 418-419 help buttons case study,

427-429 inserting, 415 Property Get procedure,

422-423 Property Let procedure, 422-423

clauses. See statements cleaning up code copying and pasting in single statement, 55 last row, finding, 54 selections, 53-54 variables, 55 With...End With, 56

Clear All Breakpoints command (Debug menu), 45 cloneDataBlocks() function, 513

Close & Delete command

(File menu), 295 Close function, 366 CloseAndKill() function, 297 closing add-ins, 502

files, 295-297

Word documents, 366

clsEmployee object, 420 cmdBrowse_Click() function, 465

code cleaning up copying and pasting in single statement, 55 last row, finding, 54 selections, 53-54 variables, 55 With...End With, 56 debugging backing up/moving forward, 45 breakpoints, 44-45, 50 hovering, 48 Immediate window,

45-48 running to cursor, 45 stepping through code,

42-45 watches, 48-50 editing, 56-58 examining in VBE, 36-37 constants, 37-41 optional parameters, 37 properties, 41-42 protection, 477-478

collections, 33

Areas, 74

creating in class modules,

425-427 creating in standard modules, 424-425 Names, 133 SeriesCollection, 188 UserForms, 434-435 ColName() function, 101

Colo's Junkroom Web site,

297 colors active controls, 448-450 cells, 84-87 charts, 186 text, 87-88

column charts, 195 ColumnExists() function, 412-413

ColumnHeaders() function,

380 columns column numbers, 125-126 copying all columns, 227 subset of columns, 228-229 referencing, 123

Columns property (Range object), 68 CombineWorkbooks() function, 300-301

combining

UserForms, 170-171 workbooks, 300-301 ComboBoxes, 166

comma-separated values (CSV), 350

command buttons, attaching macros to, 492-494 CommandButton1_Click() function, 220, 446

CommandButton2_Click()

function, 220 CommandButton3_Click() function, 221

CommandButton4_Click()

function, 221 commands. See names of individual commands

CommDlgExtendedError

API function, 462 CommentFitter1() function,

0 0

Post a comment