Index_F

 < Day Day Up > 



F

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 > 



Microsoft Excel 2003 Programming Inside Out
Microsoft Office Excel 2003 Programming Inside Out (Inside Out (Microsoft))
ISBN: 0735619859
EAN: 2147483647
Year: 2006
Pages: 161

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net