Fmp

validation, 82-83, 132

Value property (SpecialCells function), 72 variables advantages of, 55 arrays advantages of, 383-384 declaring, 379-380 defined, 379 dynamic arrays, 385 emptying, 382-383 filling, 380-382 multidimensional arrays, 380

one-dimensional arrays,

380 passing, 386 transposing, 384 For statements, 106 object variables, 113-114, 182-183

VBA (Visual Basic for Applications), 29-30. See also forms advantages of, 12-13 arrays advantages of, 383-384 array formulas, 129 declaring, 379-380 defined, 379 dynamic arrays, 385 emptying, 382-383

filling, 380-382 multidimensional arrays,

380 names, 136

one-dimensional arrays,

380 passing, 386 transposing, 384 collections, 33 compared to BASIC, 12,

29-30 conditional formatting array formulas, 129 case study, 128-129 setting up in user interface, 126-127 setting up in VBA, 127 constants, 37-41 debugging techniques backing up/moving forward in code, 45 breakpoints, 44-45, 50 hovering, 48 Immediate window,

45-48 running to cursor, 45 stepping through code,

42-45 watches, 48-50 error handling alerts, turning off,

473-474 client training, 474-475 code protection, 477-478 Continue, End, Debug, Help error message, 467

Debug button, 467-470 encountering errors on purpose, 474

Err object, 472 File not loaded completely, 394 ignoring errors, 472-473 multiple error handlers,

0 0

Post a comment