Microsoft Excel 2002 Visual Basic for Applications Step by Step (Step by Step (Microsoft))

Tab Order dialog box, 316

tables. see also ListObjects

cell references, 152

columns, captioning, 150

columns, inserting, 146

creating, from external sources, 142–145

creating, from internal sources, 140–142

data sources. see data sources

filter states, different for multiple, 152–153

filtering, by top 10, 148

header row, moving to, 152

Total row, adding, 151

task panes, 76

text boxes

adding to user forms, 310

errors, checking for, 328–329

initializing, 311–314

text files, opening with macro, 39–41

Text Import Wizard, 40

Text property, 122

ThisWorkbook property, 140

3-D formatting of shapes, 194–195

tiling windows, 15

Toolbox

displaying, 307

for user forms, 306

transparency in shapes, 192

trapping errors, 256–259

Trust Center dialog box, 29

trusting macro-enabled worksheets, 28–35

2007 Microsoft Office components, xvi–xvii

Type Conversion Functions, 241