T

/t filename switch, 74

Tab function, 986

tab order of controls, Properties window (VBE), 425

table style, 935

tabs

color , 935

font, 935

TabStrip control, UserForms, 419

Tag property, UserForms, 443

Tan function, 986

tangent of numbers , 986

task pane, 29

templates

creating, 82-83

defaults and, 82-83

introduction, 80-81

new, 934

viewing, 81-82

Terminate event, 439, 661

TestGetOption procedure, 881

testing

add-ins, 708

applications, 121-122

UserForms, 434-435

text

displaying with MouseOver event, 615-617

processing, 102

text boxes, Help system, 784, 786-787

text files

access, setting position, 980

accessing, 841

binary access, 841

bytes, number of, 985

close, 977

closing all open , 980

controlling access, 979

csv (comma separated variable), 78

CSV (Comma-Separated Value), 844

current position, 986

dif (Data Interchange Format), 79

end, 983

export features, 844

exporting ranges to, 845-846

file mode, 983

file number, 843

file position, 843

filtering, 848-849

import features, 844

importing data, 845

importing to ranges, 847-848

next available file number, 983

opening, 842

opens, 980

output line width, 981

PRN, 844

prn (formatted text), 78

random access, 841

read position, 985

reading from, 842-844, 979

sequential access, 841

sequential, returning characters , 984

sequential, writing to, 981

slk (Symbolic Link), 79

text (txt), 79

TXT (Tab-delimited), 844

write position, 985

writing to, 843-844

writing variables to, 980

Text functions, category, 308

text strings, RefEdit control, 453

Text Tools utility

Apply button, 539

ApplyButton_Click procedure, 544

background, 536

Check box, 539

Close button, 539

CreateWorkRange function, 544

design goals, 537

efficiency, 544-545

Help button, 539

Help file, displaying, 549-550

Module1

VBA module, 540-542

Operation ComboBox, 539

overview, 535-536

Proc1 ComboBox, 539

Proc2 ComboBox, 539

Progress bar, 539

RibbinX code, 550-554

settings, saving, 545-547

StartTextTools procedure, 538

Text box, 539

Undo, 547-549

UserForm, 538

UserForm1 code module, 542-544

UserSelection object, 547

Text Tools workbook

UserForm, 537

VBA module, 537

worksheet, 537

TextBox controls

properties, 431

SpinButton controls and, 441-443

UserForms, 419

The Spreadsheet Page Web site, 975

this array is fixed or temporarily locked error, 989

ThisWorkbook property, 178

time

current, 986

hour , 984

minute, 985

number of seconds since midnight, 986

seconds, 985

Time function, 986

Time statement, 981

Timer function, 986

TimeSerial function, 986

TimeValue function, 986

title bar, UserForms, 511-513

title extended property, 839

ToggleButton control, UserForms, 419

ToggleHelp procedure, 786

ToggleNumLock procedure, 891

TogglePageBreakDisplay callback procedure, 744

ToggleWordWrap procedure, 771

ToggleWrapText function, 347-348

Too many Dynamic Link Library (DLL) application clients error, 990

Too many files error, 990

toolbars

creating, 757-759

custom, 115, 931

limitations to old-style, 756

simulating, UserForms, 513-515

VBE, 141

toolbox

controls, combining, 445-446

controls, customizing, 445-446

icons, 445

new entries, 446

pages, new, 445

tips, text, 445

track number extended property, 839

transferring, one-dimensional arrays, 339

TRANSPOSE function, 296, 339

Trim function, 986

Trust Center dialog box, 861

turnkey applications, 107

TXT (Tab-delimited) files, 844

type extended property, 839

Type mismatch error, 989

Type statement, 981

type-definition character, 941

TypeName function, 986