UEU-co logo

T


Previous Page

Next Page

Index

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

Previous Page

Next Page

Leave a Reply


Time limit is exhausted. Please reload the CAPTCHA.

Categories

apply_now Pepperstone Group Limited