T

tab order, 448

TableExists() function,

411-412 tables. See pivot tables

TabOrientation property

(Tabstrip), 437 TabStrip1_Change() function, 437

Tabstrips, 436-438 tags (XML), 436, 350 Test() function, 315-316 text files case, changing, 322-323 color index, 87-88 control tip text, 448 finding strings in, 98 importing, 297-298

delimited files, 392-394 files with less than 65,536 rows, 387 files with less than

98,304 rows, 394-397 files with more than

98,304 rows, 397-398 fixed-width files,

388-391 one row at a time, 395-397 reading and parsing,

298-299 retrieving numbers from, 93 Text Import Wizard, 38-39 writing, 398-399

Text Import Wizard, 21, 38-39

delimited files, 392-394 files with less than 98,304 rows, 394-397

files with more than 98,304

rows, 397-398 fixed-width files, 388-391

TextCaseChange() function,

322-323 Textcolor() function, 87-88

TextToColumns() function, 396

time to execute code, calculating, 315-316

time/date of last save, retrieving, 81 timers, 460 titles, 192-193 To clause, 104 toggle buttons, 436 toolbars

Control Toolbox, 494 custom toolbars buttons, 488-489 creating, 487-488 deleting, 487-488 drop-downs, 489-490 icons, 489

remembering position of, 490-491 forms, 17

macro buttons, assigning macros to, 16-17 Stop Recording, 14, 22 UserForm toolbar, 433 Visual Basic, 13-14

Toolbars command (View menu), 13 Toolbars menu commands, Visual Basic, 13

Tools menu commands

Add-Ins, 500 Macro, 14 Options, 118

References, 360 VBAProject Properties, 502

Top 10 AutoShow feature (pivot tables), 271-274

Top10ByRegionReport() function, 277-279

Top6CEOReport() function, 272-274

totals (pivot tables)

grand totals, 250 percentage of, 286 running totals, 287-288 subtotals adding, 254

automatic subtotals, 254 suppressing, 249

TotColumns() function, 254

tracking national debt, 340-341

TrailingMinusNumbers parameter, 478

Transforms (XSL), 352

transparent forms, 451-452

TransposeArray() function, 384

TransposeData() function, 310-311

transposing data, 310-311, 384

TrapAppEvent() function, 417

TrapChartEvent() function, 419

trapping events application events, 416-418 embedded chart events, 418-419

trendlines, 193-195

Trendlines object, 193-195

TrimNull() function, 465 troubleshooting missing Word objects, 361

turning off alerts, 473-474 Type property (SpecialCells function), 72

Type...End Type statement,

429 types

ExcelCoords, 509 UDTs (user-defined types), 429-432

TypeText() function, 367

0 0

Post a comment