| < Day Day Up > |
|
F-test, 4
F1 through F15 keys, 127
F5 macro keyboard shortcut, 35
F8 key, 34
F8 macro keyboard shortcut, 35
F9 key, 119
F9 macro keyboard shortcut, 35
FaceId property, 376
FACT function, 97
factorial of a number, 97
facts, 342, 343
Favorites list, 145
Favorites toolbar button, 146
Field object, 482, 494–95
FieldInfo parameter, 133
fields
changing within PivotTables, 359
placing on user forms, 420
Fields collection, 493, 494
Fields property, 491
file extensions, 283
file format constants, 136
File item on Insert menu, 45
File Open dialog box, 45, 384
file picker dialog, 293
File Search feature, 282
file searches, limiting, 285
file settings, managing, 140–41
File Transfer Protocol site, 520
file types, specifying for a search, 286
FileDialog dialog box, 291–94
FileDialog object, 281, 298
determining if a file exists, 294
displaying the Open and Save As dialog boxes, 291
enhanced with Office 2003, 282
FileDialog property, 292
FileDialogFilters collection, 293
FileDialogFilters file, 281
FileDialogSelectedItems collection, 293, 294
FileDialogSelectedItems file, 281
FileExists function, 291
FileExists property, 294
FileExists2 function, 294
FileFormat parameter, 136
FileName parameter
of Open method, 130
of OpenText method, 133
of SaveAs method, 136
FileName property, 282, 284
FileOpen dialog box, 388
files
adding the list of most recently used, 136
determining the existence of, 291, 294
finding, 291–94
locating, 120, 281–82
maintaining, 282
manipulating, 281
navigating through large, 276
opening existing in Word, 458
reading from external, 296
retrieving data from, 282
returning all, 282–85
returning the name of selected, 387
searching for a value, 298
searching for all modified, 285
testing for open, 279
text format, 131
writing to external, 295–96
files folder for a Web page, 522
Files tab in Web Options dialog box, 522
FileSaveAs dialog box, 388
FileSearch object, 281, 298
FileSearch property, 282, 291
FileSystemObject object, 294
FileType property, 283, 286
FileTypes file, 281
fill color of a cell, 233, 234
fill patterns, 234, 235
Filter property, 491, 493
FilterFile procedure, 298
filters, setting, 158
Filters property, 293
financial calculations, 208–12
FIND function, 203–5
Find Printer button, 147
FindControl method
of CommandBar object, 367, 368
of CommandBarControl object, 375
of CommandBars collection, 366
getting an object pointer, 506
FindEmptyCells procedure, 176
FindFile method, 120
FindLastMonthFiles procedure, 285
FindLastRow function, 426
FindWordandExcelFiles procedure, 286
Finish button, 441
FINV function, 4
First button, 425
firstdayofweek argument, 216
FirstPageNumber property, 154
firstweekofyear argument, 216
FitToPagesTall property, 154
FitToPagesWide property, 154
fixed arrays, 66
fixed-length strings, 60
flattened reports, 342
floating command bar, 370
folder picker dialog, 293
folders within projects, 42
FollowHyperlink method, 146–47, 536
font color, changing, 88
Font object, 231
Font property, 233, 402
font style for displaying code, 51
fonts, formatting, 231–33
Fonts dialog box, 390
FontStyle property, 232
FooterMargin property, 154
For Each...Next loops, 28, 78
deleting all but one sheet, 152
exiting prematurely, 79
moving through the Workbooks collection, 129
saving every open workbook, 137
FORECAST function, 4
ForeColor property, 402
foreign keys, 470
Form Editor, 43
Form Grid Settings option, 51
FormApp.xls, 419
Format Cells dialog box, 16
custom data formats in, 217
custom number formats available in, 195
displaying with tabs, 386
Format menu, 46
Format method, 350
Format parameter, 131
FormatChart procedure, 338
FormatDateTime function, 424
FormatNumber routine, 424
formatting
cells, 233–38
charts, 338
worksheet elements, 230–31
Formatting toolbar, 16
forms. See user forms
Forms folder, 42
Formula Auditing toolbar, 16
formula bar, 19
Formula properties of Validation object, 188
Formula property, 356
FormulaLocal property, 123, 124
formulas, 21
defining chart titles as, 325
displaying in cells, 15
recalculating in worksheets, 156
returning as text strings, 123
storing names of ranges as, 181
For...Next loops, 28, 77–78
adding around periodic interest calculations, 210
exiting prematurely, 77
iterating through each item in collections, 316
nesting inside one another, 78
syntax of, 77
FoundFiles collection, 281, 285
FoundFiles file, 281
FoundFiles property, 282
four-digit year, including, 60
Frame control, 408
deleting, 409
placing a group of option buttons in, 409
surrounding a collection of label and text box controls, 439
surrounding OptionButton controls, 438
frames, 408, 528
From clause, 476
From parameter of PrintOut method, 148
FTP site, 520
full name of a workbook, 140
FullName property, 245
Function procedures
calling, 101
compared to Sub procedures, 85
creating, 100
defining, 98–104
elements of, 99
in formulas, 101
running, 101
syntax of, 99
functions
built into VBA, 196
converting values, 61
defaulting to Public, 310
finding all or part of a date or time, 214
IS family of, 194
listing all available, 22
marking as Public, 304
public, 309
with the Select statement, 477
statistical, 3–5
for summary calculations, 206
values returned by, 98
fv (future value) argument
of PMT function, 208
of PV function, 212
of RATE function, 211
| < Day Day Up > |
|