Excel VBA Macro Programming

F

Fill.OneColorGradient method, 283

Find method, 276

First name and last name , reversing, 219 ‚ 220

Fixed-length strings, 19

Flags property (CommonDialog), 247, 252

Flags property (UserForm), 280

Font dialog, 112 ‚ 113

Font property (UserForm), 94

For Each loop with Exit For statement, 41

For Each loops , 39, 41, 235

For Each..Next loops, 132 ‚ 133, 207, 210, 275

Format function, 50 ‚ 54, 222

characters for user -defined, 51

date/time format characters, 53

formatting characters, 54

predefined date and time formats, 52

predefined format names , 51

sections of, 52

Forms. See UserForm

Formula toolbar, User Defined Formula on, 257

Formulas

absolute and relative, 241 ‚ 244

coloring cells that contain, 251 ‚ 253

displaying in a comment box, 213 ‚ 215

For..Next loop with Exit For statement, 41

For..Next loops, 20, 38 ‚ 39, 44, 196, 198, 247 ‚ 248

Frames, 102

FreezePanes property (Windows object), 151

Function argument data types, 31

Function (keyword), 27

Function parameters, help with, 8

Functions

commonly used, 47 ‚ 60

conversion, 49 ‚ 50

date and time, 54 ‚ 60

public and private, 30 ‚ 31

vs. subroutines, 26

ways of using, 29 ‚ 30

writing, 28 ‚ 30, 221