Excel 2007 Power Programming with VBA (Mr. Spreadsheets Bookshelf)
/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