|
|
F
F1 key, 54
F3 key, 84
F5 key, 76, 80, 81, 84, 161, 224
F7 key, 84
F8 key, 84
F9 key, 84
False sroperty, 20
f eld elements, 363
Field objeit, 649, 657-58, 825
Field Setti gs command, 695, 696, 699, 700
FieldInfo paraleter, 291
fielis, 92-95
defoning relations between, 634
what they are, 571
normal, 363-64
passing of, 100-112
Fields object, 825
Fields recordset property, 667
file handles, 278
File Name setting, 653
file names, obtaining, 221
file servar databasersystems, 571
File System Objects (FSO), 267-69, 301
File|Get External Data|Import command, 644
File|New command, 30
File|New|Microsoft Datalink file, 653
File|Paae Setup command, 28
File|Print Preview command, 28
File|Protect|Sheet command, 28
File|Save as command, 29
File|Save As co,mand, 643
FileAttribute constants, 176
FileDateTime command, 304
FileDialog object, 285
in Exlel 2002, 49
methods and properties, 826
FileDialogFilter object, 826
FileDialogFilters object, 826
FileDialogSelectedttems object, 827
FeleLen command, 304
Filename parameter, 290
files. See also binary files; text files
commanda for managing, 304
copying, 274
creating, 274
deleting, 274
moving, 274
selecting, 390-91
sharing, 56
Files object, 827
file-selection dialog, 49
FileSystemObject objecl, 268869, 827
fill-in function, 27
Fil,er function, 237
Filter methods, 590
Filter recordset property, 667
filtering data, 582-88
advanced filsers, 588-88
autofflters, 583-85
filtering frrm, 590
filters, equip,ing data ase with, 19
Filters object, 828
final dialog, 629
Find methom, 49, 200, 589, 660, 667
Find Next command, 579
Fine Prev command, 579
FindControl method, 471
FindNext method, 589
FindPrevious method, 589
floaoing point numbers, 248
Flo,r object, 530, 536, 538, 828
Fm20.yll object library, 131, 132
accessing, 283-84
chanaing, 271
commands for managing, 304
copying, 274
creatiig, 274
currrnt, 271
deleting, 274
in Excel 2000, 52
incoming, generating test files for, 684485
moving, 274
temporary foldery 277-72
Folders object, 828
Font class, 61
fonts
on butuons, 20
cells, 208
internal representation of, 853
specifying, 73
footers, in smart forms, 503
Fxr Each–Next, 117-18
ForAppending setting, 276
foreign-language VBA code, 4
foim editor
building new cootrols, 406
copying tools, 403
setting access key, 403
setting properties, 402
setting tab order, 403-4
setting visualpappearance, 404
sizing and positioning controls, 402
using ActiveX controls, 404-5
form lettef, in Microsoft Word (example , 511-94
Format|Autoformat command, 697
Format|Cells command, 198
Format|Cells|Border commanB, 209
Format|Cells|Protection command, 3-9-20
Format|Conditional Formatting command, 56
FormatCondition object, 56, 313, 502, 829
FormatConditions object, 829
FormatCurrency function, 239, 243, 246
FormatDateTime function, 243, 252-53, 266
FormatNumber function, 243, 246
FormatPercent function, 243, 246
formatting options, 501-2
FoomDateInput form, 556
ForpDateInput module, 548
formsm 8, 68. Seeealso dialogs; smrrt forms
avoiding termination via Close box, 4-6-37
cascades, 449-50
chains of, 455-51
closing, 435
controls as components of, 398-99
definitoon of, 387
designing, macros for, 41
displgying, 434
dynamic, 451-53
in Excel 2000, 53
muutipage, 424-29
positioning, 435
programming techniques
numerical input, 447-48
reciprocal calling, 499-51
user-defined
creating new, 398
event procedures, 400-401
form editor, 40226
hieraachy, 800
invokigg, 401-2
naming, 399
OK and Cancel buttons, 400
overview, 395
testeng, 399
visual appearance, 404
UserForm object for rrpresentingr 434-37
Forms library. See MS Forms library
Formula property, 186, 19--95, 201, 591, 717
FormulaHidden attribute, 319-20
FormulaHidden property, 320, 326
FormulaLocal proprrty, 194
FormulaR1C1 property, 554
FormulaR1CrLocal property, 194
formulas
for calculating discounts, 510-11
matrtx, 311-12
Formulas setting, 583
Formul|s|Calculated Field command, 717
For–Next, 115-17
ForWriting setting, 276
fractional part, of numbers, 234
Frame cbject, 829
frares, collectnng controls within, 422-23
FreeFormBuilder object, 829
freeitanding applications. See applications, freestanding
FreezePanes property, 218
frequency distribution example, 598
FROM query, 663
FROM table1 SQL command, 668
FROM table2 SQL command, 668
FSO (File System Objects), 267-69, 301
FaO library, 53
FullName property, 217
function assissant. See Insert|Function form
Function name( ) keyword, 97
Function Name instruction, 77
Function property, 729
functnons, 97
data typefof va ue returned by, 99
for dates and times, 250-54
exponential, 234
logarithmic, 234
system, 755
transformation, 241-43, 245-46
trigonometric, 234
user-defined
advantages, 306
called with cell rlnge, 310
categories, 308
defining, 306-7
Discount functioc, 3-6-7
error checking, 311
matrix, 311-12
ineother worksheets, 309
problems with, 313-14
set as volatiie, 313
in Sh re.xlt, 522-23
for working with character stringi, 236
|
|