Index_T

---

T

tab bar

in the Excel interface, 21

on the Excel window, 14

TAB key

key codes for, 127

shifting the focus to the command button, 404

Tab Order dialog box, 45

Tab Order item on the View menu, 45

Tab parameter, 133

Tab Width code formatting option, 50

TabFixedHeight property, 416

TabFixedWidth property, 416

TabIndex property, 402, 403

table format, specifying for PivotTable items, 355

table numbers, determining from Web sites, 531

tables

adding rows to, 478

changing the value of columns in, 479

compared to worksheets, 467

copying to open Word documents, 460

joining, 476

removing rows from, 479

retrieving all rows and columns from, 472

retrieving rows from multiple, 476-77

TabOrientation property, 416

Tabs collection, 415

tabs in Options dialog box, 50-52

TabStop property, 402, 403

TabStrip control, 415

Tag property

of CommandBarControl object, 375

in Workbook_Open routine, 434

tags, 520

Taiwanese era dates, 133

Target range, 275

task identification number, 446

Task Manager, forcing hidden applications to close, 458

task panes, 20

tasks, informing users about, 67

template add-ins, included in Visual Basic 6, 250

Template parameter of Workbooks Add method, 129

templates

classes as, 299

creating, 14, 534

for creating add-ins, 256

modifying, 259-61

temporary variable, 309

Terminate event, 311, 400

testcondition argument, 76

TestControl routine, 379

TestPlants procedure, 125

tests, 286

text

accepting from users, 405

aligning in a message box, 69

concatenating, 198-200

determining if a cell is, 193-95

manipulating, 193-205

in a message box, 67

reading and copying, 298

referring to, 194

returned by the InputBox method, 123

text boxes

hiding characters entered into, 406

validating entire, 405

text files

importing, 45

importing modules from, 55

opening, 134, 295

reading using VBA, 296

representing spreadsheet data, 132

saving deleted code in, 56

standard procedure for writing to, 295

text format of files, 131

Text Import Wizard, 132

Text property

of Characters object, 326

of ListBox control, 413

of TextBox control, 405

text responses, accepting from users, 71

TextBox control, 401, 405, 408

TextCodePage parameter, 136

TextColumn property, 413

TextLength property, 406

TextOrProperty property, 285

TextQualifier parameter, 133

textual formats for communication across the Internet, 536

TextVisualLayout parameter

of OpenText method, 133

of SaveAs method, 136

Thawte Consulting, 38

thesauruses in the Research task pane, 20

ThisWorkbook module, 498

ThisWorkBook object, 267

ThisWorkbook property

of Application object, 119, 135

Close method, 138

FullName method, 140

Path method, 140

referring to a different workbook, 145

RunWizard subroutine, 434

Save method, 135

SaveAs method, 135-36

Thomson Profiles collection, 8

ThousandsSeparator parameter, 134

ThousandsSeparator property, 529

three-dimensional reports, 342

tilde (~) in the SEARCH function, 203

time and date serial numbers, 213

time entries, searching for all in one month, 163

time formats, square brackets ([]) in, 217

time functions, 213-16

time period, adding to a date or a time, 214

time serials, 216

time units, 215

Timer function, 214

times

exceeding 24 hours, 217

handling, 60

manipulating, 213-17

TimeSerial function, 214, 215

TimeValue function, 214

TINV function, 5

title bar

in Excel window, 19

of a message box, 68

titles

specifying for add-ins, 242

specifying for Web pages, 522

To parameter of PrintOut method, 148

toggle, 19

Toggle Breakpoint item on the Debug menu, 47

Toggle Total Row button, 9

ToggleButton control, 407

tool tips

controlling the display of, 50, 51

displaying expected formula parameters, 21

toolbar button, assigning a macro to, 32

Toolbar Name box, 32

Toolbar Options button, 49

toolbars

adding buttons to, 260

compared to menus for custom macros, 33

creating, 32, 377

customizing, 49

moving, 49

removing buttons from, 261

showing or hiding available, 49

Toolbars item on the View menu, 45

Toolbars tab page, 32

Toolbox

adding more controls to, 48

displaying objects, 45

toolbox floating toolbar, 401

Toolbox toolbar, 395

Tools menu, 48, 433

ToolTips, turning on and off for toolbars, 51

TooltipText property, 375

Top property

of ChartObject object, 337

of CommandBar object, 368

of CommandBarControl object, 375

of a user form control, 402

of UserForm object, 398

TopIndex property, 413

top-level Office objects, 457

TopMargin property, 154

total row, displaying, 9

TotalsRowRange property, 542

TrailingMinusNumbers parameter, 134

TransactionEffect property, 417

TransitionPeriod property, 417

translation utility, 20

trapping

events, 399

VBA errors, 82

tree view, presenting projects in, 41

TREND function, 5

triggers for a Chart object, 329

TRIM function, 196

Trim function in GetDBQuery routine, 508

trusted source, adding, 40

twip, 71

two-digit years in VBA, 60

two-dimensional report, 342

.txt (text) file. See text files

type, as a reserved word in VBA, 209

type argument

of PMT function, 208

of PV function, 212

of RATE function, 211

type element of a Function procedure, 99

Type parameter

of Add method, 151

of an element tag, 548

setting to xlValidateTextLength, 198

Type property

of CommandBar object, 8

of CommandBarControl object, 22

of Field object, 494

of Parameter object, 490

of Validation object, 188

Type statement

creating a temporary variable for, 309

defining a new data type, 73

defining property routines, 308

---