F

FACT() function, 104 Factorial function, 104, 105 FileDialogFilters collection object, 284-288 FileDialogFilters object, 359 FileDialog object, 282, 283-284, 359 dialog types used with, 284 Open dialog box of, 289 FileDialog property, of Application object, 284 FileDialogSelectedItems collection object, 284-288 FileFormat argument, 281, 282

File input and output (I/O), 279-295. See also VBA file I/O methods opening/saving workbooks, 281-282 in Word Find program, 303 Workbook and Worksheet objects and, 281-282 Filename argument, 281, 282, 347 filename string element, in Blackjack program, 247, 249 File numbers, assigning, 289 File Picker dialog box, 287 FileSystem object, 282, 288

members of, 290-291 FileSystemObject object, 282 Fill button, Click() event procedure of, 323 Fill colors, 15, 442 Fill control, 301 FillFormat object, 431 FillMap() sub procedure, 416, 419 Fill property, 431 FilterIndex property, 287 Filters property, of FileDialog object, 285 Find() method, outputting results of hand to Blackjack worksheet and, 265 Fixed length string variables, 37 Floating point data type, 47 Floating point numbers, 32 Font method, 171 Font object, 174 Font property, 174

of Command Button control, 18 Frame control and, 218 Font size, Scroll Bar control and, 219 For/Each loop, 106, 205

looping through range and, 175-177 Worksheet objects in Worksheets collection and, 230 ForeColor property, of Label control, 220 For keyword, 104 For loops, 103-106 Format Axis dialog box, 392 Format() function, 53, 231 Formatting, with Range object, 171 Form design, in Word Find program, 298-300 Forms

ActiveX controls added to, 212-213 adding to project, 209

custom dialog boxes designed with, 215-233 designing with VBA, 208-233 modal, 214-215 showing and hiding, 213-214 Forms toolbar, 10, 133 Formula property, 120, 122, 145 FormulaR1C1 property, 122

Formulas, programming into worksheet cells, 120-123 For/Next loop, 103, 105, 108, 111 Forward slash (/), in XML elements closing tags, 334 Frame control, 212, 218-220, 266

in Blackjack game, 239 Freeforms, 427 Function, defined, 64 Function calls, 66 Function procedures, 64-65, 97 Fun with Strings program, 43, 45-47

Biorhythm Awareness

Biorhythm Awareness

Who else wants to take advantage of biorhythm awareness to avoid premature death, escape life threatening diseases, eliminate most of your life altering mistakes and banish catastrophic events from your life.

Get My Free Ebook


Post a comment